I am looking to create a duration between two dates but before the second date.

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I am looking to create a duration between two dates but before the second date. Example: Accident occurred day 1-12-19 and observation date is 12-28-18. I want to know how many dates was the most resent observation date is from the accident date.
Photo of Casameira Reyes

Casameira Reyes

  • 470 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
Try this as a formula numeric field

ToDays([Accident Date] - [Observation Date ])