Good Day~
I have a Referral number that is based on our Fiscal Year. If the date is 1 Oct 13 through 30 Sep 14 then the RF# will be R140001. Instead of changing manually I tried an If Then statement for our FY2015 (1 Oct 14 through 30 Sep 15) but I cannot get it to work.
Any help would be greatly appreciated.
Thanks in advance~mjc