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
That won't always give you the last 3 months though, will it? If you're at the beginning of a month, say 3rd of Oct, startOfMonth() will get you to 1st of Oct, less two months, 1st of Aug, you'd only get 64 days.
I think what Roja was after is more like created > startOfDay(-90)
I guess it depends on how you interpret the question.
I would always interpret it as "Issues created within a period of 3 months back" in which case:
- "created > -90d ORDER BY created DESC"
would be more accurate IMO as i 90 days roughly adds up to 3 months.
However, if your thinking of it as if I am on any day in October, I want the see issues created for the months August, September and October (the past 3 actual months) . then the other Query is correct.