Help

DATETIME_DIFF for a specific date

Topic Labels: Formulas
Solved
Jump to Solution
926 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Currently_Jason
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

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

Perfect. That makes sense. Much appreciated.