Skip to main content

Counting Days between two Date Fields

  • September 18, 2019
  • 6 replies
  • 73 views

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

6 replies

  • Author
  • New Participant
  • September 18, 2019

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


JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • September 19, 2019

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


JonathanBowen
Forum|alt.badge.img+18
  • Inspiring
  • September 19, 2019

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)


  • Author
  • New Participant
  • September 19, 2019

this is sooooo helpful!
Thanks a mil!


  • New Participant
  • December 7, 2021

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


  • New Participant
  • December 7, 2021

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