Query

  • Thread starter Thread starter 116
  • Start date Start date
1

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
 
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
Click to expand...

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.
 
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.
 
Back
Top