VBSCRIP "DateValue in SQL giving "Data Type Mismatch" - why?
Posted on 2006-11-10
Hi, I am using the following to calculate number of records that have two date fields using the same date. However one of the date fields stores BOTH date and time - the other only Date. Both fields are set as Date data types.
Problem is that when this statement runs, my data access page throws up "Data Type Mismatch" error.
Why is this?
SELECT COUNT(*) FROM tbl_main WHERE DateValue(Date_Time_Completed) = Date_Created