DateDiff Error Why?

[Fede]

Hi,

I have two dates, Shipping Date and Delivery date...

I wrote this on a query

Select ID CoDe --> from Table1 --> where (DateDiff("d",[table1].[shipping Date],[table1].[Delivery date],2)>2)

What's Wrong ? The Query doesn't work...


Thank You

 

[Rabbie]

Just try Select ID CoDe --> from Table1 --> where (DateDiff("d",[table1].[shipping Date],[table1].[Delivery date])>2)

You don't need the the firstdayofweek parameter when you are working in days.

 

[Fede]

Ok Thank You very much now is all right!!!!

 

[Rabbie]

Glad to be of help

 

[boblarson]

And if you are working with tables where the name of the field is in only one table (or you are just using a single table), you can shorten your code up by removing the table reference as it only needs the field:

 from Table1 --> where (DateDiff("d",[shipping Date],[Delivery date])>2)