VB wrote:
> 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.

Is this helpful? ...

select sysdate now, add_months(sysdate, -1) one_month_before from dual

best,
Martin