Skip to Content
0
Former Member
Sep 10, 2007 at 03:31 PM

get the previous year's period for the variable

102 Views

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