QB Formula to categorize months

Question

I have the following summary report:

What I would really like to do is somehow get the row grouping (Dispatch Date) to be based off of the following groupings: Current Month, Previous Month, Next Month, All Others.What would be the most efficient way to get this done? Currently, I am looking at creating a few extra fields in the table and calculating the current month and the dispatch date relevant to the current month for all the records in the table.
------------------------------Niraj Shah------------------------------

MarkShnierYou · Answer

Try thisvar date DDFirst = FirstDayOfMonth([Dispatch Date]);IF($DDFirst = FirstDayOfMonth(Today()),                               "1. Current Month",$DDFirst = FirstDayOfMonth(AdjustMonth(Today(),-1)), "2. Previous Month",$DDFirst = FirstDayOfMonth(AdjustMonth(Today(),1)),  "3. Next Month",                                                                                                    "4. All Others")------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community