QUERY USING DATES 1

[NETHROW]

I'M TRYING TO PERFORM A QUERY ON A (SHORT)DATE FIELD
WITH AN INPUT MASK OF 99/99/0000;0;_.

THIS IS WHAT I HAVE IN THE DATE FIELD AS CRITERIA
>&quot;«Expr»&quot;=#12/1/2002# And <=#12/5/2002#
I GET A DATA TYPE MISMATCH IN CRITERIA EXPRESSION ERROR

HOW DO I PERFORM A QUERY USING A SHORT DATE FORMAT BETWEEN 2 DATE RANGES?

 

[Darrylles]

Hi,

Where is the query performed?

Where is it defined?

I ain't gonna guess on this one.

Regards,

Darrylle

&quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot;

 

[NETHROW]

THE QUERY IS PERFORMED IN A STANDARD QUERY USING THE SYSTEM DEFINED SHORT DATE. I AM ENTERING THE INFO IN THE CRITERIA SECTION OF THE DATE FIELD.
THANKS,
NETHROW

 

[67peshawar294]

nethrow,
In the criteria box, for your date in the query, type
Between [Enter 1st date] and [Enter last date]
or
Between #1/1/02# and #12/02/02#

The &quot;enter 1st date&quot; and &quot;enter last date&quot; are parameters that will appear when you run the query.
Or the second way will just give results between the given dates.
jim

 

[Darrylles]

Hi Neth,

The query you wanted was in the Query Builder then?
(i.e. not in a macro nor vb)?

Regards,

Darrylle &quot;Never argue with an idiot, he'll bring you down to his level - then beat you with experience.&quot;