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
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
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())
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
You are the man! Thank you very much.