Select data from certain quarter

[enak]

Is there a way to select the data from the current quarter if all I have is today's date?

Thanks,
enak

 

[raskew]

Hi-

To respond, we'd need to know if it's calendar year or fiscal year and, if FY, when does it start.

Bob

 

[PHV]

SELECT ...
WHERE Format([Date field],'q')=Format(Date(),'q')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[enak]

PHV, thanks for the reply. It worked. I may need more help later so stay tuned.