dates: Comparing just the date parts of datetimes

[dantebothermy]

Is there a simple way to subtract the time from a datetime field, so when I compare dates, I'm always comparing the dates at 12:00 am?

I'd really prefer not to convert all my dates to strings.

Thanks,


Dante

[ck9663]

Here are some options.

-- CK

[sagark]

You can use 'DateDiff' function which the parameter you want.