DateDiff formula

[IYG]

Hello,
I create query that subtract “schedule date” (mm/dd/yyyy) and “deliver date” (mm/dd/yyyy) to calculate difference deliveries days. I used function DateDiff different ways but query doesn’t work.

Expr1: DateDiff("mm/dd/yyyy","SCHEDULE DATE","DELIVERY DATE »")
And I have error: “data type mismatch in criteria expression” or doesn't work.

Thanks for helping.

 

[boblarson]

The Date Diff function uses this syntax:

Expr1:DateDiff("d",[Schedule Date],[Delivery Date])

 

[IYG]

I still have error: “data type mismatch in criteria expression”

 

[boblarson]

Then one, or both, of your date fields is not stored as a date, but as text. use CDate to convert it/them.

 

[IYG]

Bob,they stored as a date (short date format -6/12/1995).

Thanks for your help.

 

[boblarson]

then did you use the square brackets like I showed, or did you use the quotes in your original example. You don't use quotes.