Querying by Date 1

[AT76]

Hi All

I have a table that has Date values like:

2/26/2007 3:34:52 PM

I would like to query this table by ShortDate (Ex. 02/07/2007).

Is there a way to do this? Thanks!

 

[lespaul]

maybe:

SELECT * FROM TableName WHERE Int(DateField) = #1/1/2006#

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[AT76]

Thank you Leslie!

One more question, What if I have to do this for a date range. Ex Between #02/02/2006# And 03/03/2006# ?

Thanks again!

 

[AT76]

I got it:

Int(DateField) Between #2/26/2007# And #3/2/2007#

Thanks Again!