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

  • Thread starter Thread starter Fred Palmer
  • Start date Start date
F

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
 
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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
Back
Top