Filter out year? (1 Viewer)

[raydan]

In my DB im trying to determine the aniversary date of a loan closing. I can't seem to get the query to ignore the year and just show me the loans that closed in upcoming month regardless of what year. This is what I have so far, what else do I need.

thanks,
Raydan

SELECT Loans.LoanID, Loans.EndDate, Loans.LoanLender, Loans.CustomerID
FROM Loans
WHERE (((Loans.EndDate)>DateAdd("m",-1,Date())));

 

[FoFa]

Well I would think it would list any data where the enddate was greater than a month before the run date. I don't see where year is a factor.
What is it giving you?

 

[raydan]

Well im getting results for this year. 2 records returned. 3/8/2006 and 4/10/2006. There are several others from 2005 that it should be returning, but the query is omitting an year but the current one.