Using Between / And

[justlearning2003]

Hey,

I am creating my query and when I use the following criteria
Between [Start Date] And [End Date]
The query do not return any records if I use a single date. IE 5/27/03
But if I use 5/27/03 to 5/28/03 then it returns records for both days.
Any ideas?

Thank you

 

[Chesterex1]

Surround the date with #
eg. #06/05/03#
So that the query recognizes the data as a date.
Thanks
Chett

 

[humbleprogrammer]

BETWEEN only shows records that are between the two dates not the dates themselves. Try something like:

>=[Start Date] AND <=[End Date]

 

[justlearning2003]

Hey,

thanks for the replies. I just figured out the field is question here is a text field and not a date field. Below is an example if what would show in the table.
4/18/03 11:53:18 PM
Any ideas on how to just take the &quot;4/18/03&quot;
out of this field?

Thanks

 

[humbleprogrammer]

Is there any reason why you have it set to a text field? The easiest solution would be to change it to a Date/Time field.

 

[justlearning2003]

hey,

If it was up to me i would change it, but Unfortunately I don't have the power.

HeHe