search date

[hugz via AccessMonster.com]

i want a search function that could find a date field in text form. I used
the Like "*"... function but it can only retrieve dates by entering a
numerical date in the search textbox. i want a search function that could
retrieve a record even by typing the word June and not 6/14/2005.

pls help...

--

 

[Klatuu]

Your question is not clear.
Is the field a Date/Time data type?
When you say "search box", what do you mean?
What would typing in "June" mean?
Does it mean just June of the current year?
Does it mean everything from the January 1 for the current year through the
end of June?
Does it mean all records for the month of June regardless of the year?