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

Thread view:

Thread rating:

Branden - 29 Nov 2005 22:29 GMT

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

Branden

mscertified - 29 Nov 2005 22:39 GMT

Look in Help for the 'DateDiff' function

Dorian

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

fredg - 29 Nov 2005 22:48 GMT

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

You can use
DateValue([SomeField])
or
Int([SomeField])

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

John Vinson - 29 Nov 2005 23:22 GMT

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

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

John W. Vinson[MVP]