Between dates in a query

[RonMcIntire]

All:

I have a date field of birthdays in a query (mm/dd/yyyy) and wish to filter them with a start and end date.

I can do it with the "Between: [Start and End]" operator in the criteria box when the date is a string type but I don't understand how to filter if its a date type field.

Is there a way without converstion to a string?

Thanks,

Ron

 

[LonnieJohnson]

The same way.

Go to query design view.
On the query's criteria line under the field in question put...

Between [Enter Start Date] And [Enter End Date]

This will give the users two prompts. They must enter it in the proper format with the slashes 01/01/06

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[HarleyQuinn]

You could enclose your dats with #

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

You could enclose your dates with #

e.g. #19/10/1981#

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

I'll get it right the second time...

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[RonMcIntire]

Tnank you both for your response. I understand now what I was doing wrong.

Ron