Forum Discussion

NicholasNeilio1's avatar
NicholasNeilio1
Qrew Member
5 years ago

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

------------------------------
Nicholas Neilio
------------------------------
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    not 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
    ------------------------------