Using SQL's DATEDIFF through Access 1

[Mugs321]

Hi all,
I didn't know if this question should be written in this forum or the SQL one. I decided on this one since the error is being thrown from Access.

I am trying to add DATEDIFF to one of my queries as such:

"DATEDIFF(Week, '" & Date & "', prod_User.ExemptionDate)<=3"

When I run the query I get the following error:
"...query parameter produced this error: The object doesn't contain the automation object 'Week'"

The above DATEDIFF code works perfectly fine when typed directly into SQL server... any ideas?

 

[PHV]

What about this ?
"DateDiff('ww', Date(), prod_User.ExemptionDate)<=3"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mugs321]

Perfect!

I'd tried the abbreviations but didn't include the quotes!