How do I capture just the date from date/time field in an SQL Dat.

E

ehudson

I'm creating a query in MS Access and I want to extract just the date portion
(02/14/06) of a date/time field from an SQL Database table.

How do I structure the DatePart function in the query or is there another
way to code this?
 
O

Ofer

Check the DateValue function

DateValue([FieldName])

will return the date only without the time
 
Top