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

Topic Labels: Dates & Timezones
771 2
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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"


2 Replies 2

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.

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