Is there a function to get only the date from a full date and time variable

[Fred Palmer]

I have a table that has 2 columns that contains a full
date and time - Start_date_time and End_date_time. I want
to build a query to select all the rows for a date where
only the date are equal or in the range.

Is there a function to get only the date from a full date
and time variable and use it in my query design.

Thanks

Fred

 

[Test]

Found answer to my own question -

DateValue()

Thanks

 

[[MVP] S. Clark]

There are functions available like DatePart() to help you parse date and
time information.

or the Between...And construct

Select f1, f2 from table1
WHERE somevalue between start_date_time and end_date_time.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-