Is there any easy way to get the date which is 6 months older than today?
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://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#date-and-time~native-functions
https://community.experianaperture.io/discussion/549/date-formatting
Thank you so much @Josh Boxer it worked :)
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
https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/create-functions/#date-and-time~native-functions
https://community.experianaperture.io/discussion/549/date-formatting
Thank you so much @Josh Boxer it worked :)