Need Quarter Report


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
 
Ad

Advertisements

C

Chris2

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
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.
 
Ad

Advertisements

M

MGFoster

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
DatePart("q", DateColumn)

E.g.:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top