Error on Query with DateSerial()


Joined
Sep 8, 2012
Messages
1
Reaction score
0
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!
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Dateserial 5
DateSerial formula help 4

Top