Format function for quarter

  • Thread starter Thread starter Del
  • Start date Start date
D

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.
 
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.
 
Back
Top