Jeff,

Year = A similiar error, Error Parsing Line 1 at 29 error = (

DatePart = error Parsing line 1 at 33

I am using Northwind.sdf Employees table which has a Birthdate field for the example

cmd.CommandText = "SELECT * FROM Employees YEAR(GETDATE())"

cmd.CommandText = "SELECT * FROM Employees DATEPART(yy,GETDATE())"