To Display Current Year+2 and Current year -2

[#1]

Hi All,

I have a field called "Production Year"

I need to display  " Current year + 2 and Current year -2 "

Eg: Current Year = 2014

I need a list box containing

2012, 2013, 2014(Current year), 2015 and 2016...

Can anyone pls help me with this..

Thanks,

praveen

[#2]

[#3]

I am getting the Table as how I need. but its not affecting the data. Can u help me with this ?

[manideep78]

Praveen,

Change the name of "ProductionYear" as "PRDCTN_YR_F" in my script

or else

change the name of "PRDCTN_YR_F" as "ProductionYear" in your script.

Motto here is to establish link between your table and temp table

Simple change. Now your data will get affected.

Regards,

Manideep

[#5]

Hi Manideep,

I did those changes already.

I changed the names as "PRDCTN_YR_F" in both.

Again getting an error.   

Since the Schema name is attached. I am getting as  Yeartable.PRDCTN_YR_F  in temp table and QVS_SHOW.PRDCTN_YR_F as names

So I couldnt join.

I tried renaming it, then I faced an issue as the year filter was not working.

i.e.  After joining, it is bringing all data from QVS_SHOW.PRDCTN_YR_F. whereas I need only 2012,2013, 2014,2015 and 2016

[manideep78]

please send me the sample app along with sample data

[#7]

Thanks Manideep.