Forum Discussion

Mike's avatar
Mike
Qrew Member
4 years ago

Formula for subtracting dates

If I wanted to use a number saying for saying how many days have gone by since a specific date, how would I handle that formula field?  So like "3" would mean it's been 3 days (Today) since the scheduled date (March 20th).  Any help would be amazing!

Thank you!

------------------------------
Michael Brumfield
------------------------------
Formulas and functions

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    If you want to have a formula result in a number as to the number of days, you cvan do

    ToDays(Today() - [Scheduled date])

    The inner part would result in a Duration of 3 days, but a Duration is not a number, it is a sense of time ...

    I find it much easier to convert that to the number of days.

    If you want to add days to a date it would be like

    [Scheduled date] + Days(3)



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • Mike's avatar
      Mike
      Qrew Member
      4 years ago
      Oh my gosh, Mark, this worked so great!  Thank you so much!!

      ------------------------------
      Michael Brumfield
      ------------------------------