How to substract months

[Kutti]

Hi All,

I have a requirement in my project to substract the months based on the selected month from prompt page in report studio .

Ex: if i select jan 2010 from the date prompt then i need to get the data from July 2009 to Jan 2010
as  per the australian calander year.

Please help to get this logic.

[TheDarkKnight]

Hi,
u could use _add_months function like below
_add_months(<parameter>,-10)
where
<parameter> - prompt value selected
-10 - no of months u want to subtract

Hope this helps

Cheers!!
Dinesh