Use autoCalender.MonthsAgo after formatting a date

[simki]

Hi guys,

i have a data set where the "SUBMIT_DATE" is formatted like this: DD.MM.YYYY

Now i need to format it correct to use it with the .autoCalender.MonthsAgo function to get the values with the highest months ago. This is what i need to get working:

Max(Date(SUBMIT_DATE,'DD.MM.YYYY').autoCalendar.MonthsAgo)

I tried a lot but didnt get it running, so now i hope someone here can help me 🙂

Regards

Simon

[Seyko]

Hello,

The autocalendar table is supposed to be auto-generate. Following this link to go to this online help. You can obtain this table by your data manager (after you applicated the synchonization). Normally, the *.MonthsAgo field is created.

cordially.

[Anil_Babu_Samineni · Accepted solution]

That is field hence you can't use. To achieve format perhaps this?

Date(Date#(Max(Date(SUBMIT_DATE,'DD.MM.YYYY')), 'DD.MM.YYYY'), 'Wanted Format Here')