Date comparisons

[joethall]

The follow line of SQL will work perfectly finding 300+ entriess


but when it is executed it finds xero;

SELECT * FROM tblComps WHERE (Active=True AND Year([DateCreated])=#2016#)

The above text is assigned to the variable mySQL in VBscript and then executed with:

mySQL = "SELECT * FROM tblComps WHERE (Active=True AND Year([DateCreated])=#2016#)"
jRs.Open mySQL, jConn, 3, 3

Can anyone explain this behavior?

Thanks

Joe

[ranman256]

Year may be numeric, you dont need the # sign.

[joethall]

It still finds zero records without the two double-quote marks !