chrisline90
New member
- Local time
- Today, 02:38
- Joined
- Sep 3, 2024
- Messages
- 5
Hi,
I have an Access DB that tracks expiry dates. Lots of expiry dates for several hundred employees. I produce reports for Managers so they can see when people are approaching specific expiry dates so they can take action and book courses etc.
I had a request from the managers to format the reports so that dates are highlighted in this way:
This works and gives me the formatting I need for:
The problem is, how do I get round the problem in November and December when the formatting rules for NEXT MONTH (+1) and THE MONTH AFTER (+2) need to account for the incremented YEAR for the +1 (in December) and +2 dates (in November and December).
I would be very grateful for any advice.
I have an Access DB that tracks expiry dates. Lots of expiry dates for several hundred employees. I produce reports for Managers so they can see when people are approaching specific expiry dates so they can take action and book courses etc.
I had a request from the managers to format the reports so that dates are highlighted in this way:
- Dates due to expire THIS month
- Dates due to expire NEXT month (+1)
- Dates due to expire the MONTH AFTER (+2)
This works and gives me the formatting I need for:
- This Month
- Next Month (+1)
- The Month After (+2)
- Dates that have expired
The problem is, how do I get round the problem in November and December when the formatting rules for NEXT MONTH (+1) and THE MONTH AFTER (+2) need to account for the incremented YEAR for the +1 (in December) and +2 dates (in November and December).
I would be very grateful for any advice.