Showing dates in current month only

[fistja]

Greetings,



I'm trying to run a query that displays employees with a birthday in the current month... I'm completely lost on what to use for criteria.

Thanks,
James

[Bob Fitz]

This may work for you if the birthday field is a date.
Put this:
Exp:Month(YourDOB FieldName)
as a new field

Use this as criteria:
Month(Date())

[fistja]

You are the man! Thank you very much.