
Difference of two datetime columns caused overflow at runtime
Hi,
The Crystal Report uses an SP where date diff function is used.
In the Sp it is used in the following fashion:
AND ( (convert(float,DATEDIFF(second, Birth_Date, Date_Spec_Collected)) <
86400)
in the WHERE clause.
When a verify database is done on the report, it gives the error:
"
Difference of two datetime columns caused overflow at runtime
"
Thanks for any help.
Regards
Brijesh