Skip to main content

Calculating # of days that passed

  • July 29, 2024
  • 1 reply
  • 0 views

Forum|alt.badge.img+9
  • Participating Frequently
  • 9 replies

I have a table with two date fields- "date created" and date "completed". I would like to create a formula that calculates the number of dates that passed from the date the record was created to the date it was marked as "completed". What's the right formula for this?

1 reply

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • July 29, 2024

 

Off the top of my head, I think you want something like this. 


DATETIME_DIFF({completed}, {started}, "days")

 

Please forgive any typos. I am on my phone and not a computer. 


Reply