I have a request to build 2 filters, one that selects the previous month to date and one that calculates the previous year to date. So, today is Aug 15, this filter would find all the rows that have the date of July 1 to July 15. The other would find all rows that have the date of January 1 to August 15, 2011.
Does anyone have this for Oracle?
Thanks.
snapman85 (BOB member since 2004-02-23)
Sort of. I used that page for some other calculations, and can use one of them to get the first day of the previous month. But I need a calculation for the same day (as today) in the previous month. As a variable, they were using this: =RelativeDate(CurrentDate();-DayNumberOfMonth(LastDayOfMonth(CurrentDate())))
But the syntax is different for creating objects in designer, and it’s not my strong point 
snapman85 (BOB member since 2004-02-23)
…if today is sysdate then the same day last month is
Nick Daniels 
(BOB member since 2002-08-15)
Thanks, that is working.
snapman85 (BOB member since 2004-02-23)