topic Re: Use autoCalender.MonthsAgo after formatting a date in App Development

Use autoCalender.MonthsAgo after formatting a date

simki — Sat, 16 Nov 2024 20:09:30 GMT

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

Re: Use autoCalender.MonthsAgo after formatting a date

Seyko — Mon, 02 Sep 2019 10:11:33 GMT

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.

Re: Use autoCalender.MonthsAgo after formatting a date

Anil_Babu_Samineni — Mon, 02 Sep 2019 10:41:46 GMT

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')