Question - Passing a date

From: VB <vodkablokey_at_gmail.com>
Date: 1 Sep 2006 03:45:00 -0700
Message-ID: <1157107499.938924.243870@i3g2000cwc.googlegroups.com>

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. Received on Fri Sep 01 2006 - 05:45:00 CDT