Page 1 of 1

MS Access - Format Date As Fiscal Quarter

Posted: Tue Dec 16, 2014 8:26 am
by magicrat
Here's the elusive format formula to take a date and determine year and quarter.

Code: Select all

FiscalQuarterAndYear: Format$(DateAdd("q",1,[MyDateField]),"q" & " - " & "yyyy",0,0)
Example Output:

Code: Select all

MyDateField FiscalQuarterAndYear 14-Mar-14 2 - 2014 14-Sep-14 4 - 2014 14-Oct-14 1 - 2015 14-Dec-14 1 - 2015