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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Check the DateValue function

DateValue([FieldName])

will return the date only without the time
 
Back
Top