Number of Days Between Dates

Question

I am trying to generate a report of sorts that shows the number of days between TODAY and the most recent occurrence of something in one of my fields? What is the best way to do this?

quickbasecoachd · Answer

Make a formula numeric fieldTodays(Today() - [my other field])

ltduranltduran · Answer

My other field is a numeric field that tracks the number of events that occur each day. These events don't occur everyday. How can I count back to the most recent day that one of these events occurred?

quickbasecoachd · Answer

You will need to get that "most recent day" as a field on the record so that it is available to use in a formula.&nbsp; If these Events are in a child table, you will need to edit the relationship to create a Summary field of the maximum Event Date.

ltduranltduran · Answer

I'm not quite understanding how to get the most recent day into the equation. I have a date field, but the only one that matters is the most recent.

quickbasecoachd · Answer

Do you have a date field on the same record as where you need the formula or is that date field in a child table?&nbsp; Do you have relationships?&nbsp; Or do you simply have a bunch of date fields on the record itself and you want the most recent to be used.

Forum Discussion

Number of Days Between Dates

Related Content

Calculating number of days between two date fields

Roundup whole number

Distinct Dates

Formula Date Field

Date Field Formula