Forum Discussion

StevenPearson's avatar
StevenPearson
Qrew Assistant Captain
5 years ago

Specific Date Formula

I'm looking for help with a date formula. I need a field that will return the following Tuesday's date regardless of what day it is currently.  I tried this formula but it didn't work:
NextDayOfWeek(ToDate([Invoice Date]), 3)

Any help would be appreciated.

------------------------------
Steve Pearson
------------------------------
Formulas and functions
  • AhuvaBrown's avatar
    AhuvaBrown
    Qrew Cadet
    5 years ago
    Did the formula return the wrong date, or was there some sort of error?

    If it returned the wrong date, you might want to try NextDayOfWeek(ToDate([Invoice Date]), 2), because the NextDayOfWeek function starts at 0 (Sunday = 0, Monday = 1, Tuesday = 2 etc).

    ------------------------------
    Ahuva Brown
    ------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    So if today is Monday the 1st, do you want the result to be Tuesday the 2nd?  Or Tuesday the 9th?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • StevenPearson's avatar
      StevenPearson
      Qrew Assistant Captain
      5 years ago
      If today is the Monday the 1st, it should return Tuesday the 2nd. If it were Wednesday the 3rd, it would return Tuesday the 9th. Right now, the formula I used returns nothing.

      ------------------------------
      Steve Pearson
      ------------------------------
      • BlakeHarrison's avatar
        BlakeHarrison
        Qrew Captain
        5 years ago
        NextDayOfWeek(Today(),2)

        This formula would return the next Tuesday, based on Today's date. I see that your original formula uses a field [Invoice Date], but it looks like you're also using the ToDate function on it - is it not a Date field? If it IS a Date field (not a Text, WorkDate, or Date/Time field), you should be able to leave that function out and just do this:

        NextDayOfWeek([Invoice Date],2)

        ------------------------------
        Blake Harrison
        bharrison@datablender.io
        DataBlender - Quick Base Solution Provider
        Atlanta GA
        404.800.1702 / http://datablender.io/
        ------------------------------