expiry dates report

[Tia]

Hello,
I have a list of exiry dates for the employees with different dates,
how can i generate a report that gives me the expiry dates of this
month only

Thank you in advance

 

[Klatuu]

Use a query as the reports record source that filters the records based on
the exipery date:

WHERE Format([ExpireyDate], "yyyy/mm") = Format(Date(), "yyyy/mm")

 

[KARL DEWEY]

WHERE Format([expiry date], "yyyymm") = Format(Date(), "yyyymm")