Invalid Arugment

[Guest]

I am trying to build a query with a field that contains data in the general
date format. In the criteria section, I put Between 6/1/2005 6:00:00 am And
6/30/2005 8:59 pm, and I get an invalid argument error. If I try to use the
filter button, I get the same error. But I use this same code in another
query, and it works fine. Any Suggestions?

 

[Joseph Meehan]

I am trying to build a query with a field that contains data in the
general date format. In the criteria section, I put Between 6/1/2005
6:00:00 am And 6/30/2005 8:59 pm, and I get an invalid argument
error. If I try to use the filter button, I get the same error. But I
use this same code in another query, and it works fine. Any
Suggestions?

I have not worked with date-time so I am going to make a quick guess.

Try #6/30/2005 8:59 pm# rather than 6/30/2005 8:59 pm .