You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
How do we create a query to return target dates outside of "now"?
The current query I have is "target end" <now() and status != done
But I want to be able to send a notification outside of the actual due date, and send it 3-5 days before the due date.
Hello @Karl Jackson and welcome to the Community!
There's multiple date functions that you can use, such as startOfDay(), endOfDay(), startOfMonth(), endOfMonth(), startOfWeek(), endOfWeek(), and more are available here.
If you want to query for issues that are 3-5 days before the due date, you could do something like:
The "-" goes back in time, so -3d is 3 days ago.
Hope this helps
Awesome! If you wouldn't mind accepting this answer so that others can benefit from it in the future that would be great!
For your query, do you need to have parantheses around the last clause:
"target end" > startOfDay(-5) and "target end" <= endOfDay() OR ("target end" < -5d and status != done)