Hi. I want to produce a report with custom dates in Atlassian Analytics. The default dates will be 10/1 of last year (e.g. 10/1/2022) and 9/30 of this year (e.g. 9/30/2023) since this is a compliance report but I want the facility to allow the user to change the dates if they want.
I am using Calendar control. Logically thinking the function {CURRENT_CALENDAR_YEAR.START.SUB(3,'Month')} should work. But for some reason the calendar stops at 1/1/2023 and the subtract 3 months does now work. Can someone help me get a formula to get the dates I want please?
Hi Kailash,
Can you try using the following relative date variable: {CURRENT_CALENDAR_YEAR.START.SUB(3,'month')}
The default fields for the calendar control are case-sensitive on the unit of time. Please let me know if this works for you!
I believe the reason you were seeing the calendar at 1/1/2023 is because it's storing previous data entered in the control. You can see this reflected in the dashboard URL where the control selection is hard coded.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.