Get the 6 month Older Date from Today

Mahulima

Is there any easy way to get the date which is 6 months older than today?

Josh Boxer

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

Mahulima

Thank you so much @Josh Boxer it worked :)