Need Quarter Report

[Linda]

Need Query to give Jan-Feb-March. I have date field
of "CurrentDate" can get it to give current month - or
current minus one - but I need specifically set quarters.
Any help will be SUPER

 

[Chris2]

Need Query to give Jan-Feb-March. I have date field
of "CurrentDate" can get it to give current month - or
current minus one - but I need specifically set quarters.
Any help will be SUPER

A quick test shows this seems to operate nicely.

SELECT SWITCH(DatePart("q", Date()) = 1, "Jan-Feb-March",
DatePart("q", Date()) = 2, "Apr-May-Jun",
DatePart("q", Date()) = 3, "Jul-Aug-Sep",
DatePart("q", Date()) = 4, "Oct-Nov-Dec")


Sincerely,

Chris O.

 

[MGFoster]

Need Query to give Jan-Feb-March. I have date field
of "CurrentDate" can get it to give current month - or
current minus one - but I need specifically set quarters.
Any help will be SUPER

DatePart("q", DateColumn)

E.g.:

DatePart("q", #4/25/04#) = 2 Second quarter.