How do I compare just the date portion of date time fields in SQL?

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

Guest

What is the Access SQL syntax for comparing only the date portion of two date
time fields?

Branden
 
What is the Access SQL syntax for comparing only the date portion of two date
time fields?

Branden
Click to expand...

WHERE DateValue([DateFieldA]) = DateValue([DateFieldB])


John W. Vinson[MVP]
 

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

How do I capture just the date from date/time field in an SQL Dat. 1
Chg "day" portion of DateAdd Date 3
Trim Time off Date 4
How get rid of time portion of dates? 11
Select time only from a date/time field 8
Access Compare records in same access table 0
Extracting Date from Date/Time Field 2
Compare two dates and use the earlier date 8

Back
Top