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
Fixed it.
The source data was actually "20180704130000" so I had to remove the " first.
See attached the soruce CSV file