DateAdd function

[Solly]

I am connecting with Access database through JetOLEDB.
I have to select from employee table adding 3 years to the joineddate.The following code gives the error " No value given for one or more required parameters"
-2147217904

Select dateadd(year,3,employee.joineddate) from Employee

Thanks. [sig][/sig]

 

[MichaelRed]

Check the syntax for date add.

Year needs to properly specified. I think it is "yyyy", but check whatever in help

[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]

 

[rockhead]

Does the field employee.joineddate exist in the table? I've seen this error many time if I'm missing a field in an Access Table or query.. [sig][/sig]