Search with due date is blank and less than current date

[Ramesh Krishnan]

when i searched using below jql, shows empty

Search with due date is blank and less than current date

due IS EMPTY AND due < now()

When i run due date and blank separately its shows record, when i combine doesn't show.

due IS EMPTY - Getting records

due < now() - Getting records

when i join those 2, no records displayed: due IS EMPTY AND due < now()

is wrong with syntax or jql?

[Bill Sheboy]

Hi @Ramesh Krishnan 

The suggestions provided to use the OR rather than the AND keyword should work, unless...there is something else incorrect in your query, such as missing parentheses around the Due Date conditions. 

If so, please post the entire query you are using to provide more context.  Thank you.

Kind regards,
Bill

[PgM Support]

Hi @Ramesh Krishnan,

Use the query below instead:

due IS EMPTY OR due < now() 

AND means both conditions should be met.

Regard,

PgM Innovations

[Marc - Devoteam]

Hi @Ramesh Krishnan 

due IS EMPTY OR due < now()

[Ramesh Krishnan]

already  i tried this also, not working