Hi,

I have been asked to author a report for Finance (having not done this
before) and I want to pass set up a view which will take the assembled
data from 01/09/05 until the End of the month previous ie 31/08/06 but
up until Midnight. THen next month for September.

Is there a way to get the previous month's date by using TO_DATE
Sysdate and minusing the month by 1 (The report will always be run on
the 1st of the next month).

Any and all help would be appreciated.