Number of Days Between Dates

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
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?
Photo of ltduran

ltduran

  • 590 Points 500 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
Make a formula numeric field

Todays(Today() - [my other field])
Photo of ltduran

ltduran

  • 590 Points 500 badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
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.  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.
Photo of ltduran

ltduran

  • 590 Points 500 badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
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?  Do you have relationships?  Or do you simply have a bunch of date fields on the record itself and you want the most recent to be used.