JQL Filter to find overdue items will not work

Question

This filter works right up until I specify the project, and then returns nothing even though I know the duedate fields should give me some results. I can switch the project to a next gen board and get results, but my current team's board is not a next gen project because those still like key features.

Here is the filter I'm using

project = SNET AND issuetype = Epic AND status != Done AND duedate < now()

If I remove the project part, i can return the entire organization's projects. Changing the < to a > doesn't return anything either despite changing the Due date field

It seems like this should work...but it doesn't.

Dietrich Lehr · Answer

figured out the issue...for some reason the duedate value didnt work when referencing the project and I had to use the the specific name of the custom field "deadline date". Weird...

Dietrich Lehr · Answer

that filter you asked me to run returns 12 epics

Jack Brickey · Answer

Why do you think it is failing? Are you saying the filter results in no matches? Are you sure that there are epics that are overdue in the SNET project? What does the following reveal?

project = SNET AND issuetype = Epic AND status != Done