date time in vba

[blad3runn69]

howdy, I was hoping someone could point in the right direction
re: in vba evaluate combined value from a date field and time field against current system datetime eg. (date & time) < now

how to create expression(oper ators?) (a & b) < c

thank you, muchly appreciated

[missinglinq]

Access is pretty flexible as long as the resultant "date/time" looks like a real date/time. Something like this should work:

Cdate(A & " " & B) > Now

Linq ;0)>

[blad3runn69]

cool stuff, - got it working.

Thankyou so much for your help missinglinq, it really is muchly appreciated :)

[missinglinq]

That's why we're here!