The Date time conversion takes only single input type (FME, ISO or dd/mm/yyyy etc.) It does not allow or take multiple input types. Many times, the input data (Excel files, CSV files) comes with different string for date type field resulting the date time conversion rejection. To address the issue with the date type we have created a custom transformer. The custom transformer uses the FME “Date Time conversion” transformer multiple times with different input type for rejected part.

If the FME “Date Time conversion” gets enhancement to support multiple input date types the workspace will be simplified and will improve the performance also.