Re: Date restricter for current quarter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: MGFoster (me_at_privacy.com)
Date: 11/01/04

Next message: dlemarr: "Misc Time - Continued"
Previous message: Tom Ellison: "Re: remove character during query"
In reply to: Haji: "Date restricter for current quarter"
Messages sorted by: [ date ] [ thread ]

Date: Mon, 01 Nov 2004 20:20:51 GMT

-----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-----
Haji wrote:
> 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.

Next message: dlemarr: "Misc Time - Continued"
Previous message: Tom Ellison: "Re: remove character during query"
In reply to: Haji: "Date restricter for current quarter"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: What does the script do
... Hash: SHA1 ... with some variations for an else-if component ...
(comp.unix.shell)
Re: MS Access iterators?
... Hash: SHA1 ... implied in the criteria (the WHERE clause) of the query. ...
(comp.databases.ms-access)
Re: MS Access iterators?
... Hash: SHA1 ... implied in the criteria (the WHERE clause) of the query. ...
(comp.databases.ms-access)
Re: String field contains "abc" using ASP to query Access database?
... >> Hash: SHA1 ... > Unfortunately the WHERE clause is generated dynamically. ... Prev by Date: ...
(microsoft.public.access.queries)
Re: How do I structure the where clause to select rows whose data contains spaces?
... Hash: SHA1 ... > the above statement simply doesnt insert anything into the TEMP table, whereas the following statement works fine: ... > How do I structure the where clause to select rows whose data contains spaces? ...
(microsoft.public.access.queries)