Help

Calculating # of days that passed

Topic Labels: Dates & Timezones Formulas
488 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Limi
6 - Interface Innovator
6 - Interface Innovator

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 1

 

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.