Month and Day only not Year to create query

[ssalem]

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.

[ssalem]

Ok I figured it out. This is what I had to do.

I made two expressions in the query, one pulling the month useing datepart("m",[Fieldname]) and one datepart("d",[Fieldname])
Then within the expressions on criteria I put datepart("m",date()-15) and datepart("d",Date()-15)

My query returned all dates 15 days before my Fieldname expired without looking at the year.

[June7]

So you need to calculate the renewal date (1 year from issue date?) then apply criteria to retrieve records that are due in the next 15 or 30 days?

RenewalDate: DateAdd("y",1,[Bulk Fee Paid])

Can build one query with a parameter that references textbox on form for criteria. Criteria under the calculated field to return renewals due in the next 15 or whatever days:

Between Date() And Date() + Forms!formname!textbox

[ssalem]

Actually the date on the database is the date they opened the permit no matter what year it was. It always renews on the same day even if it is overdue. It does not change the Paid Fee. Their renewal date always stays the same, even if they pay it 1 month or 2 months late. That date will never change. Every year I need to send out a notification that the permit is coming up for renewal. A 30 day notice and a 15 day notice reminder.