Is there a simple formula to return the fiscal year quarter that applies to a date? I simply want January thru March to show as Qtr 1, etc.

thanks

Something like this?
"Qtr " & (((month(#12/05/2007#)-1)\3)+1)

thanks for the quick reply. i already did what you said. thanks a lot.

This will also work:

Format(YourDateFieldHere,"q")

Hi -

There are many instances when a fiscal year does not start on 1 Jan. Try the following which allows the user to specify the FY start date.

Function fGetFYQtr(FYStart As Date, pDate As Date) As Integer
'To call: from debug (immediate window)
'? fGetFYQtr(#7/1/06#, date())
'returns: 3
fGetFYQtr = DateDiff("m", FYStart, pDate) \ 3 + 1
End Function


HTH - Bob