Formula Help_ Last day of Quarter
I have this field - Month End Y/N - Formula Checkbox [Date] = LastDayOfMonth([Date]) I need this field- Quarter End Y/N - Formula Checkbox [Date] = LastDayOfQuarter([Date]) ... this would hav...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnot tested but try this
var number MonthsToAdjust =
Case(Month([Date]),
1,2,
2,1,
3,0,
4,2,
5,1,
6,0,
7,2,
8,1,
9,0,
10,2,
11,1,
12,0);
LastDayOfMonth(AdjustMonth([Date],$MonthsToAdjust))
//That will give you the last date of the quarter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var number MonthsToAdjust =
Case(Month([Date]),
1,2,
2,1,
3,0,
4,2,
5,1,
6,0,
7,2,
8,1,
9,0,
10,2,
11,1,
12,0);
LastDayOfMonth(AdjustMonth([Date],$MonthsToAdjust))
//That will give you the last date of the quarter.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------