Search Criteria

Question

How do I create a query search criteria based only on the month and day and not the year?

Answer 1

Format(<your date field name>,"mm/dd")=MonthDayCriteria

or

Day(<your date field name>) = DayCriteria AND Month(<your date field name>)=MonthCriteria

Answer 2

RunningMan,

May I make a sugest? 

The fieldname should not be between "[" and "]" instead of "<" and ">"

Answer 3

RunningMan,

May I make a sugest? 

The fieldname should not be between "[" and "]" instead of "<" and ">"

I use the greater than / less than signs only to symbolize that the user needs to decide what goes in that position.  But thank you.

Best,

RM