WB Custom Date Format to working for 20180704130000 format

rado98 Contributor



I am unable to get the following format date 20180704130000 (or 2018/07/04 13:00:00) using the workbench data transform.


As I see it the Date Format I should use would be yyyyMMddHHmmss


Schema for the filed is set to STRING as suggest in the topic below.


I had a look at the following dojo topic and article but I still cant get it to work




I have attached a screenshot of the error mesage


Best Answer

  • rado98
    rado98 Contributor
    Answer ✓

    Fixed it.

    The source data was actually "20180704130000" so I had to remove the " first.


This discussion has been closed.