# Discussions

View Only

## 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
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/
------------------------------