Future Date Formula Help
I want to create at date that is X number of weeks after another date but if the date falls less than or equal to 3 day into any given month then the date should equal the last day of the prior month....
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legend3 business days or calendar days ?
------------------------------
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
------------------------------
- Calendar Days, thanks
------------------------------
George Bramhall
------------------------------- MarkShnier__YouTry this
var RawDate = [Another date] + Weeks([X weeks as a numeric field]);
IF(Day($RawDate)<=3, LastDayOfMonth(AdjustMonth($RawDate,-1)),$RawDate)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- works like a charm, thank you Mark!!
------------------------------
George Bramhall
------------------------------
