Hi. I am using the SQL Query in Crystal 8.5 to run a select statement. When I run it, it gives no errors, but returns no data. When I run the same query in SQL Plus, it returns records. I believe the offending piece of code is:

"FREQUENCY_DATA"."FREQUENCY_DATE" = TO_CHAR(SYSDATE - 1, 'DD-MON-YY')

this is in my where clause and when I remove it on Crystal, it returns all records. When I keep it in there like I said, no records, but it will return records on SQL Plus. Any assistance would be greatly appreciated!