dynamical year range

[#1]

Hi All,

The year filed having the data from 2005 to 2080 in the database.

But we need to load only 50 years of data only.

Every 5 years they will consider as AMP.

Ex:      AMP1          AMP2         AMP3            ....           AMP15

        2006-2010   2011-2015    2016-2020         ....         2075-2080

Ex: The AMP for the current year is AMP2

Now the year range should be like this

"Previous AMP+Current AMP+40 Years" Means 2006-2010+2011-2015+40 (2006-2055)

Note: Year should be a financial Year

How to write the condition as per the Year range specification in the script which will take the year range dynamically?

Hope you understand the requirement.

Thanks in advance..

Regards

Kumar

[jagan]

Hi,

Can you attach some sample records, so that it would be easier to understand.

Regards,

Jagan.

[kaushiknsolanki]

Hi,

     Find the attachment.

     Hope this is what you want.

Regards,

Kaushik Solanki

[#4]

Hi Jagan,

Please check the attachment for sample data which i have prepared for AMP1.

Small correction in my previous post:

             AMP1

2005-Apr to 2010-Mar  (5 Years)

Like this for other AMP's.

Regards

Kumar