I am trying to make a query where it retrieves the names of the employees where their certifications are about to expire.
I have the dates when they first got certified and they expire two years from that day.
The query would retrieve those employees where the (first Cert Day) <= (first Cert Day + 2 years ) - 3 months
I want the query to return the ones who are 3 months away from being expired.
I tried adding: Dates in Column <= DateAdd("yyyy",2,[Column]) - DateAdd("m",3,[Column])
but that doesnt work.
What would be the correct format for using multiple intervals?