Format function for quarter

[Del]

In my organisation we use fiscal years (i.e. 1 Apr 03 to
31 Mar 04) but when I try to represent the date in
quarters using 'format([Date],"q")' access brings back 2
when I wanted it to show 1.

Is there a way to make access use financial year rather
than calendar year?

Many thanks.

 

[Allen Browne]

Add -3 months to the date:
DatePart("q", DateAdd("m", -3, [MyDateField]))

DatePart() returns a number, so it is better than Format() which returns a
string.