I'm trying to add a field in query design SQL EXPRESS as follow
SELECT Year([Created_Date]) as exp1
FROM Tablex
or
SELECT Datepart(year,[Created_Date]) as Years
FROM Tablex
Table comming from MSAccess
I have donne in MSAccess many time without a problem , but I get an error in SQL
what wrong , please help
Year function in sql query
ToryPatnoe
To work around this bug I'm going to make the query in the access mdb file that calculates and lists in columbs the Year, Month and Day. Then I'll set the SQLDataSource to use that view of the data instead of the table directly. However, there should be a way to use functions inside of the query designer build into the express.
yyy2k3
Error source:Microsoft Jet Database Engine
Error Message:Undefined function '[Year]' in expression
please note it adds [ ] Brakets to year
Jurgen Willis
But you said, "please note it adds [ ] Brakets to year"
That means it looks like this: [Year]([Created_Date])
Or like this: [Year([Created_Date])]
Correct Or does it add the brackets ONLY to the error message and NOT to the query itself
Tempus
websdaleandrew
jepherz
So the question is why does it added and cannot evaluate
Year([Created_Date])
I just try it on the same table in access and it works well
borix69
Than that's the problem: the adding of brackets to "Year" makes it a column identifier instead of a function name.
Are you passing that SQL statement to Access via a OleDbCommand object And if so, can you please paste that code here
Yun yang
That means it looks like this: [Year]([Created_Date]
It adds it to query grid and error message as well.
Gilles Muys
Homer Y
The sql statement is as I stated earlier
Year([Created_Date]) in the query grid