I am trying to creating 2 queries of my Permit renewals of Permits that are expiring in 15 and 30 days. My issue is that the Date on file is the original date the Permit was opened and comes up for renewal on the same month and day but not year. So i need to query on -15 days and -30 days back from the date the permit was opened.
Im rather new at this and just cant seem to get the right results. In my query under the criteria option of [Bulk Fee Paid] i put. (month(date()) & day(date())) - 15 = (month([Bulk Fee Paid]) & day([Bulk Fee Paid])
I also tried dateadd("d",-15,date()) in the [Bulk Fee Paid] criteria.
I am not sure what I need to do...but I am pretty sure it can be done.
Any quidance would be apprectiated.