I tried the DateDiff but keep getting a data type mismatch.
I need to display the number of days on a report. the data resides in a table.
InDate is in date/time format
ComDate is in date/time format
I created a query that will update a field in a new table. the field(daysdiff) is numeric (long) to hold the number of days. since this table has the InDate and ComDate from the original table already (in the date/time format), I'm updating the daysdiff field using the DateDiff......
set daysdiff = DateDiff("d",InDate,ComDate). When I attempt to run it, the data type mismatch happens.
Any ideas???????