Select Statement for date against Oracle 9i database 2

[ziggs]

I'm trying to get all incidents within a 24 hour period against an Oracle 9i database. In Crystal Reports, part of my select statement that works is:

{INCIDENT.CALL_TIME} >= (currentdatetime - 1)

In an ASP, I can use the following against the same database:

{INCIDENT.CALL_TIME} > to_date('" & oraclesysdatelessoneday & "', 'DD-MON-YY HH24:MI:SS')"

Is there anything that will equate to the above in Actuate?

 

[nagornyi]

try
INCIDENT.CALL_TIME >= sysdate-1

 

[bcaslow]

If it's in Actuate Basic you'll need something like this:

INCIDENT.CALL_TIME >= DateAdd("d", -1, Now( ) )