Query

[116]

Looking for assistance with two date fields. One is a General Date, and the
other is Short (mm,dd,yyyy). Looking to use 'Between [General Date] And
Date()'. Also the General Date is a MaxOf. I think I have a formatting
issue between the two.

Thanks
David

 

[techrat]

Looking for assistance with two date fields.  One is a General Date, and the
other is Short (mm,dd,yyyy).  Looking to use 'Between [General Date] And
Date()'.  Also the General Date is a MaxOf.  I think I have a formatting
issue between the two.

Thanks
David

While I am not sure if I can help you solve your problem, I am sure
that you will need to post some additional information in order to get
help with this. Perhaps post the actual SQL statement for the query
and indicate the behavior that you expect/don't expect. Perhaps
someone more intuitive than I will be able to understand how to help
you without more information but I suggest putting up more details.

Hope this helps you get an answer.

 

[Lynn Trapp]

What are the names of your date fields? You should be able to use something
like this in the criteria:

BETWEEN [DateField1] AND [DateField2]

The formatting shouldn't matter.