DatePart syntax in VB querying an SQL table

[Hardhat4u]

What I'm trying to do is convert a year into an integer. The date is in a SQL database and I am using VB to extract the year. The following is only part of the query but I am certain this is the problem area. The error message I receive is "To few parameters, expected 1."



Here's part of the query that seems to be where the problem lies. In the immediate window it recognizes Date but not 'yyyy'.

CInt(DatePart('yyyy', Date))

[Hardhat4u]

I no longer believe that's may problem. It's another parameter giving me that message.

[RuralGuy]

That often means something misspelled.

[Hardhat4u]

You're correct

[RuralGuy]

If you've resolved this issue then go ahead and use the Thread Tool and mark this thread as Solved.