Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved.
Learn more here!
Formula to rearrange date string: "20"+Right([Field_3], 2)+ "-" + IF (Right(Left([Field_3], 6),3))="JUN" THEN "06" ELSEIF (Right(Left([Field_3], 6),3))="DEC" THEN "12" ELSE "" ENDIF + "-" + Left([Field_3], 2) Note: can easily add to ELSEIF statement to map all 3 Character Month String Values