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
------------------------------
Question
Specific Date Formula
+7This topic has been closed for replies.
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
------------------------------
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
------------------------------
+24So 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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.