Hi All,
Need to return right 4 if length is greater than 4. Please help!!
IF Length([Year of FYE (As adjusted)]) > 4THEN Right([Year of FYE (As adjusted)],4)ELSE [Year of FYE (As adjusted)]ENDIF
Thank in advance!!
@AuditPro13
Oh, you need to give your field a Name in the Formula Tool configuration.
Cheers,
Hi @AuditPro13
What kind of error are you bumping into?
Is your field an Int Number?
If so, you need to use ToString function in combination with a ToNumber function.
IF Length(ToString([Year of FYE (As adjusted)])) > 4THEN ToNumber(Right(ToString([Year of FYE (As adjusted)]),4))ELSE [Year of FYE (As adjusted)]ENDIF
Hi @Thableaus,
The error says "The field "" is not contained in the record. Please noted the data is V_string.
The one you sent is not working currently.
