Syntax error: missing operator

[Ricter]

That is the error I'm getting for my anniversary dates query. The SQL:

SELECT LastName, FirstName, HireDate, IIF(DateSerial(Year(Date() + 1,
Month(HireDate), Day(HireDate)) < Date() + 365, Year(Date() + 365) –
Year(HireDate), Year(Date()) – Year(HireDate))
AS YearsOfService
FROM tblEmployees
WHERE (DateSerial(Year(Date()), Month(HireDate), Day(HireDate))
BETWEEN Date() AND Date()) + 365 OR (DateSerial(Year(Date()) + 1,
Month(HireDate), Day(HireDate)) <= Date() + 365;

There is a selection area over the first minus sign in the SQL after I close
the error window, if that's helpful.

 

[Roger Carlson]

You are missing a right paren just before the first plus sign:

SELECT LastName, FirstName, HireDate, IIF(DateSerial(Year(Date()) + 1, ...

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Ricter]

Bah, I should slap myself for not counting up the parentheses myself. Thanks
Roger.