Skip to main content

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

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

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



JB

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


DATETIME_DIFF(End, Start, 'days')



JB


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


WORKDAY_DIFF(Start, End)


this is sooooo helpful!

Thanks a mil!

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

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


DATETIME_DIFF(End, Start, 'days')



JB


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

Reply


Terms & Conditions