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