Searching for Date Ranges

[phd42122]

Hi All,
I'm creating a search form that has multiple optional search criteria (e.g. customer name, customer state) and I'd like to add a field to search for orders between a particular entry date. I know that the Like searches text, but is there something similar for date ranges? If Like did work, the criteria would be written as follows:
>=Like "*" & [forms]![Search Form]![startdate] & "*" AND <= Like "*" & [forms]![Search Form]![EndDate] & "*"



Thanks in advance!

[Rickyp]

You must use the # delimiter on both side of a date - "#" & Date & "#"

[Bob Fitz]

Maybe this would work:
Between [forms]![Search Form]![startdate] AND [forms]![Search Form]![EndDate]