compare dates

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

I am trying to send out notices of past due items.
my table holds duedates such as 12/4/2007 10:59:30 AM
when I run a query where currdate which is a date & " " time
is less than duedate, but my query comes back blank?
 
We can't begin to tell what's wrong with your code unless we can see it!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com
 
Okay, I just found out my problem was I had 'vardate' in my vb code and I
needed #vardate#. Sorry to take your time.
 
Back
Top