Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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.
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')