Recent content by IYG

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

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

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