tjacobsen700

Create report for jobs that have closed date is within a time period.

Discussion created by tjacobsen700 on Apr 11, 2013
Latest reply on Apr 12, 2013 by tjacobsen700
I'm trying to create a report of jobs that have closed within the last 60 days.  It is a report that will get run on a monthly basis so the end date can't be a hard coded value.

Does anyone know how to get something similar to this:

select end_date, end_date - (to_number(substr(tz_offset( DBTIMEZONE ),2, 2))/24) as ActualTimeMinus from jtx.jtx_jobs where jtx.jox.jobs.end_date in (sys:cur_date - 60)

into the report manager sql view?

Any other suggestions?

Outcomes