Compare dates using Dateserial in Access 2007 SQL

Question

I have the following SQL

SELECT P1.Column1, P1.NextApprovalDate
FROM Procedures P1
WHERE DATESERIAL(YEAR(P1.NextApprovalDate), MONTH(P1.NextApprovalDate), 1 )  
= DATESERIAL(YEAR(Date()), MONTH(DATE()) + 1, 1);

I get an error which is "Data type mismatch in criteria expression". I tried using the CDate and the Format functions in conjunction as well but continue to get the same error. The SQL runs fine when I am selecting the criteria there. How should the criteria be formatted?

Answer 1

Ok. I got this to work but it is kind of weird the way Access wanted it. The = sign never worked for the comparison. Why I don't know. The BETWEEN worked. If someone could find a way to make the '=' work, do let me know. Thanks to @Hansup for pointing me in the right direction.

SELECT P2.Column1, P2.NextApprovalDate
FROM (SELECT Procedures.Column1, Procedures.NextApprovalDate FROM   
Procedures WHERE Procedures.NextApprovalDate IS NOT NULL)  AS P2
WHERE DATESERIAL(YEAR(P2.NextApprovalDate),MONTH(P2.NextApprovalDate),1)   
Between DATESERIAL(YEAR(Date()),MONTH(Date())+1,1) And  
DATESERIAL(YEAR(Date()),MONTH(Date())+1,1);