you might get a "Undefined function 'CONVERT' in expression" in Crystal Reports if you are using Office 12 Access DB, to correct this you have to convert the left hand function,
eg,
Undefined function 'CONVERT' in expression "Crystal Reports"
CDATE({ERYTHROCYTE_SEDIMENTATION_RATE_HEADER.COLLECT_DATE}) >= cdate (2008, 07, 05)
to fix the problem, good luck
Subscribe to:
Post Comments (Atom)
1 comment:
You save me a day of work! THANK YOU FOR POSTING THIS.
I don't know why you should have to use a CDATE() function on a database field that's already a datetime data type, but you do! Thanks!
Post a Comment