Aug 27, 2020 10:55 PM
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"
Aug 28, 2020 11:48 AM
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.
Sep 08, 2020 10:58 AM
Ho my god… Thank you so much. I fell dumb now I see the problem…