Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Counting Days between two Date Fields

Topic Labels: Formulas
3180 6
cancel
Showing results for 
Search instead for 
Did you mean: 

is there a formula to count the number of days between two date fields?

6 Replies 6

I want to show how many days from start to finish.

Hi @George_Zaloom - you can do this with the DATETIME_DIFF() function:

DATETIME_DIFF(End, Start, 'days')

Screenshot 2019-09-19 at 08.37.46.png

JB

Or, if you only want to count weekdays/working days:

WORKDAY_DIFF(Start, End)

Screenshot 2019-09-19 at 08.40.03.png

this is sooooo helpful!
Thanks a mil!

Hi, How I can use DATETIME_DIFF() function, the IDE doesn’t recognizes it

Hi, How I can use DATETIME_DIFF() function, the IDE doesn’t recognizes it