Setting a criteria to find dates

[Penny]

I have a data base with employee informaiton. I need to find the end of
probation date for the year 2007. I'm not very familiar with setting criteria
and this is one i can not seem to figure out. Any help would be greatly
appreciated.
--

 

[Rick B]

Not sure what the exact answer is because we don't know the structure of
your data. I will guess that you have a field called "end of probation
date"? If so, just put the following under it as criteria...

Between 01/01/2007 and 12/31/2007

 

[Penny]

This data base consists of alpha and numeric information. under "End of
Probation" is the date. I tried what you put and i still recieve all dates.
What is happening is when i do an ascending on end of probation it scrambles
the dates. In order to bypass this i need to just look for the year 2007 and
nothing more. What other information do you require and i will try and answer.

Penny

 

[Rick B]

Is this data stored in a DATE/TIME field? Or do you have it in a text
field? If it is in a text field, why? I would always put a date entry in a
date field. You can then format that date any way you desire in reports,
forms and queries. You can also do date math on it and use criteria to
filter your list (as we are discussing here).

If this is not a date/time field, I'd recommend converting it to one. Your
normal "between" criteria should then work.