Reported By: Elevate Software Reported On: 12/19/2002 For: Version 3.20 Build 1
# 1289Using the ODBC Driver with Crystal Reports to Query on a Timestamp Field Causes an Error Crystal Reports 8.5. I am having a problem getting the ODBC and Crystal to run date selection criteria ! For example this is what the SQL where clause within Crystal looks like when we select the date of birth field:
WHERE QuickTriage."dob" > {ts '1988-09-08 00:00:00.00'}
CommentsThe ODBC driver was confusing the ts escape tag with the t (time) escape tag due to the way the parsing was done.
ResolutionFixed Problem on 12/19/2002 in version 3.21 build 1