I'm looking to do a dashboard to show certain data based on a date field that is older than one month from today. Is there a formula that can calculate if a date is older than one month from today?
Not looking to enter the date into a control each time.
Hello,
Yes, you can use the Atlassian Analytics relative date variables to generate a dynamic date filter.
For example, "Created at" < {TODAY.SUB.(1,'month')} will return all dates older than May 12th.
Let me know if you have further questions on this or how to use relative date variables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.