Need Quarter Report

  • Thread starter Thread starter Linda
  • Start date Start date
L

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
 
Linda said:
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
Click to expand...

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.
 
Linda said:
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
Click to expand...

DatePart("q", DateColumn)

E.g.:

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