Date formats Hours Minutes Seconds to month day year

[vincent721]

I am tying into a SQL database using Microsoft Access through an OBDC link. There are date fields but the dates are in month-day-year hour minute format such as the following:

11/8/2007 11:59:00 AM

I am designing a query in Microsoft Access to query the SQL database using a limiter such as the date but I do not need the hour minute second (ie., I just want to use >= 11/8/2007).

My question is this: Is there a function that will convert the month-day-year hour minute second format to the month-day-year?

I do not think the format function will work since the query will still be seeing the hours-minutes-second. Any help would be much appreciated!!

 

[GingerR]

CDate(Format([DateFieldHere],"mm/dd/yy"))

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html