← Back to Data Studio

Convert EmployeeID from Text to Date

Data Domain: Finance & administration · DRAFT only. The original source values stay unchanged. Only the normalized values are converted. Review ambiguous values before applying.

EmployeeCurrent valueAnalysisCanonical date (ISO)
EMP-1005EMP-1005 invalid
EMP-1008EMP-1008 invalid
EMP-1001EMP-1001 invalid
EMP-1006EMP-1006 invalid
EMP-1007EMP-1007 invalid
EMP-1004EMP-1004 invalid
EMP-1003EMP-1003 invalid
EMP-1002EMP-1002 invalid

Invalid dates must be corrected in source data and re-imported before conversion. No guessing and no partial migration.