Get the 6 month Older Date from Today
Is there any easy way to get the date which is 6 months older than today?
Tagged:
0
Comments
-
Hi Mahulima
Yes. Unclear if you want the month or the date as you mention both, but get the Current date then Add period (select months and negative 6) then Format date
FormatDate( AddPeriod( CurrentTimestamp('Server default'), 'Months', -6 ), 'MMMM' )
https://community.experianaperture.io/discussion/549/date-formatting
1 -
Thank you so much @Josh Boxer it worked :)
1
Categories
- All categories
- 17 Get started
- 471 Get involved
- 13 Support
- 269 Resources
- 3 Events
- Upcoming events
- 3 Event recaps
- 18 Ideas and roadmap
- 218 Community categories