Failed to Open Rowset - Select Expert Date Criteria 1

[TheLibrary]

Crystal Reports 9

Attempt to use Select Expert to limit entries based on date/time values and I get the following error messages:

"Failed to open rowset"

"Details: 22007:[IBM]Client Access Express ODBC Driver (32bit) [OD2/400 SQL] SQL0180 - Syntax of date, time, or timestamp value not valid"

Any suggestion to allow use of date/time data from database?

 

[LV]

Have you checked Seagate KB?

http://support.crystaldecisions.com...FILENAME.CRITICALDISPLAY.CONTENTTYPE.FILESIZE

 

[TheLibrary]

Found a work around!

Write a formula for a date range:
@DateRange = If {Data.Date} < CurrentDate - 31 or {Data.Date} > CurrentDate + 31 then &quot;out&quot; else &quot;in&quot;

Include in Selection Criteria:
@DateRange = &quot;in&quot;

This will only include records within +/- 31 days of today. Apply any other range of dates accordingly!