Referencing System Date in SQL Command Editor

Post Author: Maxim6469

CA Forum: Data Connectivity and SQL

I need to create a SQL statement that uses the system date in a WHERE clause, but all my known functions or keywords do not work. I have already tried the following functions & keywords:

CURRENT_DATE, Today(), Date(), Now(), SYSDATE, and Sysdate()

Are there any other ways to pull the system date into a WHERE clause in SQL Command Editor?

I'm using Crystal Reports XI

Thank-you