Bug with 2019 and 2020 year date time parse and date time diff

As you can see from my screenshot, I have a weird behaviour with my formula. It converts 2019 into 2020 for an unknown reason… Here is my formula to calculate the number of days between the download of an App and the moment where a user make a specific action. As you can see, sometimes, the user made this action multiple times, so I must use an other formula to get only the first 10 characters so I can compute it with the download date…

FirstCallDateSingle : DATETIME_PARSE(LEFT(CONCATENATE(FirstCallLookup),10),‘AAAA-MM-DD’)

DeltaInscriptionVsFirstCall : DATETIME_DIFF(FirstCallDateSingle, {:calendar:Created At​:writing_hand:t2:}, ‘days’) & " Jours"

Try using 'YYYY-MM-DD' as your format specifier for the DATETIME_PARSE function. The character A in the format specifier is used to specify AM/PM in a time, not the year.

1 Like

Ho my god… Thank you so much. I fell dumb now I see the problem…

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.