Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

DATETIME_DIFF for a specific date

Topic Labels: Formulas
Solved
Jump to Solution
398 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.