Fiscal year conversion not working

[haneen97]

Hi,
I have this code in a formula field called “FY_YEAR” to convert the fiscal year to the next year in the last quarter. It works fine in the last quarter but it does not return any thing if the month is less than 10.
********************************************************************
numbervar F_Year := Year ({CTC_UM_Denial.rvw_signedreceipt_denial});
numbervar Mon := month({CTC_UM_Denial.rvw_signedreceipt_denial});

if mon in 10 to 12 then
f_year := f_year + 1;

f_year;
********************************************************************
Please help

Thanks


Mo

 

[synapsevampire]

Try:

numbervar F_Year;
numbervar Mon := month({CTC_UM_Denial.rvw_signedreceipt_denial});

if mon in 10 to 12 then
f_year := f_year + 1
else
f_year := Year ({CTC_UM_Denial.rvw_signedreceipt_denial});

-k