custom filter not working for pulling out due dates on issues

[Julie Reviglio]

reporter = currentUser() AND duedate = startofday("-1")

Hi All,

I have this custom filter and it is not working for me, in our large Marketing departement we need to be able to view all tasks that have a due date coming up so the Manager can action it and also if they have gone past the expiry date.

Is anyone able to help me see what I have done wrong?

Thank yo u

[Rilwan Ahmed]

Hi @Julie Reviglio ,

Please try these JQL's:

1. For finding issue which are due tomorrow: 
   reporter = currentUser() AND duedate = startofday("1")
   
2. For finding issues which are due today: 
   reporter = currentUser() AND duedate = startofday()
3. For finding issues which are due today Or tomorrow
   reporter = currentUser() AND (duedate = startofday("1") OR duedate = startofday())
   
4. For finding issues whose due dates already passed
   reporter= currentUser() AND duedate <= now()
   
   

[Julie Reviglio]

Hi Rilwan, thank you for getting back to me.

I have tried your 1st and 4th options as they seem to be the ones we are having problems with mainly and when I enter them, it doesn't pull up any issues at all. For either filters.

Is there something I am missing maybe? I have entered these into the custom filters on the board we are trying to locate these dates on. Am I meant to create an automation for them as well maybe?