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(...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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
------------------------------
------------------------------
Steve Pearson
------------------------------
- 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/
------------------------------
