AnsweredAssumed Answered

Date Calculation on String Field Default Value for Fiscal year

Question asked by brad@bradoverton.com on Apr 6, 2016
Latest reply on Nov 11, 2016 by kapilkjoshi

I'm attempting to do what I thought would be a simple default value calculation on a field in Nintex form.   All I'm trying to do is calculate the fiscal year based on if month is higher than 9, add one to the year value.    The if statement works but I can't figure out how to increment the year by 1.    If I try to do "+1" all I get is 2016+1 instead of 2017.    Any help would be appreciated.  

 

fn-If(fn-GreaterThan(fn-FormatDate(Current Date, "MM"),9), fn-FormatDate(Current Date,"yyyy"),fn-FormatDate(Current Date,"y"))

 

Thanks,

Brad

Outcomes