custom filter not working for pulling out due dates on issues

Question

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

Julie Reviglio · Answer

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?

Rilwan Ahmed · Answer

Hi @Julie Reviglio ,

Please try these JQL's:

* For finding issue which are due tomorrow: 
reporter = currentUser() AND duedate = startofday("1")

* For finding issues which are due today: 
reporter = currentUser() AND duedate = startofday()
* For finding issues which are due today Or tomorrow
reporter = currentUser() AND (duedate = startofday("1") OR duedate = startofday())

* For finding issues whose due dates already passed
reporter= currentUser() AND duedate <= now()