Logic Help

[abhaysingh]

Hi GUys,

I have one fiscal year like 2012,2013 = Calendar year 2012

          2013,2014 = Calendar year 2013

      2014,2015 = Calendar year 2014

  2015,2016 = Calendar year 2015

I want the fiscal year to be shown like 2012 for 2012 ,2013

and 2013 for 2013,2014

i want it dynamic, if new year comes than this process automate and give me next year.

how i can do this?

i think it can be done by loop, any suggestion?

[swuehl]

Maybe like

LOAD

     Subfield( [Fiscal Year], ',',1) as [Fiscal Year],

     ...

[MK_QSL]

Date#(SubField('2012,2013',',',1),'YYYY') as FiscalYear

[abhaysingh]

not working

i want to represent fiscal year as my calendar year..

by above getting same output

[MK_QSL]

How your Fiscal Year field is and how you want to show !

[abhaysingh]

I think i miscommunicated .. sorry for that,

i have fiscal year like below

2012

2013

2014

2015

2016

and calendar year

2012

2013

2014

2015

so when i m selecting 2012 calendar year, fiscal year 2012 and 2013 highlighted. so i want to show this fiscal year as single field having value as calendar year which is 2012.

[Anonymous]

my customer too has a fiscal year whicjh differs from calendar year

I provided a mastercalender with additional fields for fiscal year, fiscalmonth etc.

so January 2016 is fiscal year 2015 with fiscal month nr 10

[MK_QSL]

are they in single table or different table?

[abhaysingh]

yes they are in single table

[MK_QSL]

can you provide some sample data with 4-5 lines...?