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?
Calculating # of days that passed
This topic has been closed for replies.
+29
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.