DATETIME_DIFF for a specific date

[Currently_Jason]

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

[ScottWorld · Accepted solution]

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

[Currently_Jason]

Perfect. That makes sense. Much appreciated.