DATETIME_DIFF for a specific date

Hi,

I have a formula DATETIME_DIFF(Date,28/06/2020,‘days’) This should give me the number of days between “Date” (a date field) and a specified date. I must have something wrong as it displays 18441 regardless of the date I specify.

What do I need to do?

Cheers

Jason

You can’t just type 28/06/2020 into the formula, because that is seen as either a string of text or a math calculation.

Try using the DATETIME_PARSE function with your 28/06/2020 like this:

DATETIME_PARSE('28/06/2020', 'DD/MM/YYYY')

1 Like

Perfect. That makes sense. Much appreciated.

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