JQL for returning over due issues to the auto email

[Hanan Golfeigen]

Hi all :-)

Can not accomplish this JQL , id like to return all issues that over due ,meaning all that less the due date , but seme's i need to put exact date and to refer each day separately.

any idea?

project ='xxx' AND Due <= TODAY()       --not working

project ='xxx' AND Due <= 2022-6-20    --works great

Thank you 

[Hanan Golfeigen]

Thank you Walter Buggenhout  :-)

[Walter Buggenhout]

Hi @Hanan Golfeigen,

Try the following instead of today():

Project = "xxx" AND due <= now()

Hope this helps!