Get the 6 month Older Date from 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