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