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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim Time off Date 4
Updating field based Between Dates 2
pulling a date out of a field containing both date and time 3
Date fields in SQL queries 4
How do I compare just the date portion of date time fields in SQL? 3
Date/Time criteria problem 2
Formatting date gives bad results in query 2
Splitting Date from Time in Access Project 4

Back
Top