-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Something like:
SELECT * FROM table_name
WHERE date_time_column Between DateAdd("h", -24, Date() + #1530#) And
Date() + #1530#
1530 = 3:30 PM.
Between expression translates to "24 hrs before today at 3:30PM and
today at 3:30PM."
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQf/n84echKqOuFEgEQIzmgCgwbnXm1vDIA9HGLvXHUx6Xx+LseYAn 3ql
Y8EI8rHeOzpqi3alDHGilzV9
=dJ2J
-----END PGP SIGNATURE-----
Doug1962 wrote:
I would like to run a query every date to extract only the records that
have been added to the database within my criteria for a 24 hour
period. I.E. I would like the query to extract records from 3:30 pm
yesterday to 3:30 pm today. The query is automated to run at 3:30
everyday. I am unsure of hour to express hours in my date field
parameter.