Discussions

Expand all | Collapse all

Specific Date Formula

  • 1.  Specific Date Formula

    Posted 25 days ago
    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
    ------------------------------


  • 2.  RE: Specific Date Formula

    Posted 25 days 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
    ------------------------------



  • 3.  RE: Specific Date Formula

    Posted 25 days 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
    ------------------------------



  • 4.  RE: Specific Date Formula

    Posted 25 days 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
    ------------------------------



  • 5.  RE: Specific Date Formula

    Posted 24 days 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/
    ------------------------------