Error on Query with DateSerial()

[marolir]

I have tried to run this query and I keep getting a runtime error, even when I sub the numDays variable by the DateSerial() function:

SELECT Client,
DateSerial(Year(Date()),Month(Open Date),Day(Open Date)) AS NextYear,
DateSerial(Year(Date()),Month(Date()),Day(Date())) AS todays,
(nextyear-todays) AS NumDays,
FROM table
WHERE numDays between 0 and 90

I have a date and I am trying to find out which dates have anniversary in the next 90 days.

thank you guys!