Date is <today

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that I would like to return all items that are overdue (ie the
due date is less that today

I have tried the following

<Date()

but this does not return any records (and there are records to be returned.

Any help??????

Cheers Nic
 
That should work. Only thing I can see is that the field that has your date
is not set has a date field.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iif function with two fields to look at 6
Adding a query result to a form in Access 2007 1
Excel Excel due and overdue date colours 2
Date Calculation Problem 2
dateadd conditional formating to equal yes or no 1
Help with 3 scenerio query 1
Return records entered today 14
=Date() Problem 2

Back
Top