Discussions

Expand all | Collapse all

Number of Days Between Dates

  • 1.  Number of Days Between Dates

    Posted 10-17-2017 20:12
    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?


  • 2.  RE: Number of Days Between Dates

    Posted 10-17-2017 20:28
    Make a formula numeric field

    Todays(Today() - [my other field])


  • 3.  RE: Number of Days Between Dates

    Posted 10-17-2017 20:39
    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?


  • 4.  RE: Number of Days Between Dates

    Posted 10-17-2017 20:55
    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.


  • 5.  RE: Number of Days Between Dates

    Posted 10-17-2017 21:06
    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.


  • 6.  RE: Number of Days Between Dates

    Posted 10-17-2017 21:42
    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.