Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm trying to create a variable that looks at the current year and month to decide on the content based on the simple rule:
So far I have
SET ThisYear = Year(Today());
SET ThisMonth = num(Month(Today()));
SET ThisFY = '=if($(ThisMonth)>6, $(ThisYear)+1, $(ThisYear))';
This works great - it returns 2018 for Jan-June 2018, 2019 for July-Aug 2018
I want to create a variable that will contain the value FY18 or FY19 in the above scenario.
I have tried variants of:
SET ThisFY_Full = 'FY' & right('$(ThisFY)',2);
and nothing seems to work - can someone help out.
I'm sure this is very simple - it's just that I am not achieving it.
Thanks in advance
Alexis
Try this
SET ThisYear = Year(Today());
SET ThisMonth = num(Month(Today()));
LET ThisFY = if($(ThisMonth)>6, $(ThisYear)+1, $(ThisYear));
LET ThisFY_Full = 'FY' & right('$(ThisFY)',2);
Try this
SET ThisYear = Year(Today());
SET ThisMonth = num(Month(Today()));
LET ThisFY = if($(ThisMonth)>6, $(ThisYear)+1, $(ThisYear));
LET ThisFY_Full = 'FY' & right('$(ThisFY)',2);
Thanks Sunny
I was close but not close enough!!