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

Question

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.

quickbasecoachd · Answer

Try this as a formula numeric field  ToDays([Accident Date] - [Observation Date ])

Forum Discussion

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

1 Reply

Related Content

Create a formula duration over 5 years

Looking for State abbreviation to full spelling formula

Duration Fields with Pipelines

Odd question looking for guidance

Formula Checkbox and Duration

Recent Discussions

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.

Share your feedback on the new Qrew Discussions