Date Input Mask in Query?

[DelbyJones]

We have employee dates of birth in our database. For a birthday gift exchange program, I want to generate a query that returns only the day and the month of the employee birthday (to placate those employees who wish not to disclose their exact age). I'm struggling with making a custom date input mask that will do this. Any help?

[pbaldy]

I'd use the Format() function in a query field:

Format([DateOfBirth], "mm/dd")

[DelbyJones]

It worked. Thanks so much!

[pbaldy]

No problemo!