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?
+27
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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.