Hi Experts,
I have got a requirement to calculate the previous year's month for the user entered value, we have a variable(select option, optional) for month to give the periods for the year. Now i need to calculate the higher period entered by user(i.e. TO period) -12. I tired with offset -12 but it giving the cumilative values for the periods entered by the user.
For example
if user enters 01/01/2006 to 01/03/2006 it should give the 01/03/2005 along with the 2006 periods as separate colums.
please help me out...
Regards
SS