Skip to Content
0
Former Member
Mar 25, 2009 at 03:26 PM

Calender Quarter

39 Views

I know that the Calendar1stQtr function :Specifies a range of Date values that falls within the 1st, 2nd, 3rd, or 4th quarter of the current calendar year

But what I would like to know, Is there a function that I can make use to determine which quarter the dates fall into no matter what the calender year is.

Eg : If {2/2/2008}in Calendar1stQtr Then '1st Quarter '. It displays a blank because it is not in the current year.But I want it to display 1st Quarter no matter what the calendar year it is .

Edited by: SS243 on Mar 25, 2009 4:38 PM