Calculate difference of 2 dates

Question

Find the number of days difference between 2 date fields?

Answer 1

Hi priyanka,

Use the datediff function to calculate difference in days or months or years.

Datediff('mode', start date field, end date field) here mode can be day, month or year.

DATEDIFF('day', [ORDER DATE], [SHIP DATE]) to get the difference.

Hope it helps.