Access VBA date/time

[camastanta]

Hi

How to compare a date/time via VBA with a date/time in an Access DB?

The query I use

adoRS.Open "SELECT * FROM currentposition s WHERE ((currentpositi ons.
[dateLT])=" & "#" & date_from_messa ge & "#" & ")", adoConn, adOpenStatic,
adLockOptimisti c

I only achieve to compare a date.

Anybody an idea?

Regards
Camastanta

[vb5prgrmr]

Look at the DateDiff Function...



Good Luck