adding FY suffix to year field

[#1]

Hi I have the following field in my script to work out the fiscal year. What I want to do is add a suffix of 'FY' to the years so for instance they would read 2013 FY. I believe this is achieved using the dual function but cant quite get it to work. My field is :

,If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField))) as FISCAL_YEAR

Thanks

[#2 · Accepted solution]

Hi Sid,

if you need it as a dual, just append the text to the first parameter and the base number in the second.

Dual(If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField))) & ' FY',

If(Month($(vDateField)) >= 10, Year($(vDateField)) + 1, Year($(vDateField)))) AS FISCAL_YEAR

hope that helps

Joe

[#3]

Thanks Joe it worked perfectly.

[#4]

no worries glad to help