My source dataset is DWG and destination is GDB. The source dataset has Date attributes as Char in DD-MM-YYYY. The corresponding destination attributes have to be of Date datatype, that too in M/D/YYYY format.
I tried DateFormatter transformer, with output date format string as FME Date (%D), I got the error as
The date 'FME Date (05/14/1981)' is not valid. Valid forms for a date type are YYYYMMDD, YYYYMMDDHHMMSS, or HHMMSS
For format string as %D, I got error as:
The date '05/14/1981' is not valid. Valid forms for a date type are YYYYMMDD, YYYYMMDDHHMMSS, or HHMMSS
For format string as %m"/"%e"/"%Y and %m/%e/%Y, again the above error message.
As from the error, I cannot perform the desired formation. Is there a transformer available in FME Workbench to perform desired format conversion? Or should I try something like using
SubstringExtractor and then
StringConcatenator? I need to read the documentation thoroughly to see if I can get it working.