Date restricter for current quarter

H

Haji

Hi,

Can someone tell me if there is a date restrictor for the
current quarter. For instance, this would be 10/1
through 12/31 but would change after the first of the
year.

Thanks,

Haji
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Since most companies have their own quarter definitions it is easier to
designate the quarter's beginning and ending date in the WHERE clause of
the query:

....
WHERE <date column> BETWEEN #10/1/2004# And #12/31/2004#

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQYaao4echKqOuFEgEQK1zQCcCipd4dmL6PiOoraO7NKjCpUa1YMAoLOR
UUY5BKHqjrnqAySQPmKjYK/7
=4z3/
-----END PGP SIGNATURE-----
 

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

Similar Threads

Year to Date Date Restrictor 2
How to calculate average for current quarter? 1
Querry by Quarter 7
Calculate Start and End Date of a Quarter 8
URGENT HELP NEEDED WITH GETTING AVERAGES BY QUARTER 1
Date Restrictor for this month 1
Is there a way to make positive numbers appear as +XX ? 4
Date Restrictor for Last Week 4

Top