WB Custom Date Format to working for 20180704130000 format

rado98
rado98 Contributor

Hi

 

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

https://dojo.domo.com/t5/Workbench/Loading-DD-MM-YYYY-Date-Format-from-CSV-file-with-Workbench/td-p/26978

https://knowledge.domo.com/Connect/Connecting_to_Data_Using_Workbench_4/Setting_a_Custom_Date_Format_on_a_Column_in_Workbench_4

 

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.

Answers

This discussion has been closed.