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.
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.