Formula Help_ Last day of Quarter

Question

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 have been to easy
LastDayOfPeriod assume, anyone point me in right direction

------------------------------
Nicholas Neilio
------------------------------

MarkShnierYou · Answer

not tested but try thisvar 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community