I'm trying to convert an excel date to sql datetime format in a select statement. The code fails with the following error message: "undefined function convert". Can anyone offer any advice on how to convert to datetime in an excel query? Is there another
function I should use?
"select name, address from " & "[" & tableName & "]" & "where ((CONVERT(DATETIME, hiredate, 102)) > 5/15/2012)"
Go to the complete details ...