Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you attach some sample records, so that it would be easier to understand.
Regards,
Jagan.
Hi,
Find the attachment.
Hope this is what you want.
Regards,
Kaushik Solanki
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