I have an employee table which contains, among other fields, the employee name and birthdate. I have received a request to build a report to list all employees with birthdates in a specified month, regardless of the year or birth. Been looking for a formula that would select records based only on the month number but am having difficulties. Any suggestions? I know that I can bring back all the records and hide rows that don't meet the month criteria, but I'd like to see if there was a way to bring back only the records for the selected month.
Date
Votes
2 comments
-
Harry Lewis Hi David -
Something like this?
-
David Wiser Perfect. Thanks.
Please sign in to leave a comment.