JQL Date Query

[David Hobaugh]

Hello Community,

Using Project Automation I want to run a JQL search and pass results to subsequent actions to send an email notification to user.  I created a custom date field for SHIP DATE and need the query to return tickets that are SHIP DATE minus 21 days.  What is the JQL for such a search?

[John Funk · Accepted solution]

Hi David,

Try "Ship Date" >= startOfDay(-21d)

[David Hobaugh]

Works, thanks!

[John Funk]

Great!