I am importing historical data in apex 5.0 using data workshop by converting excel spreadsheet into csv file and uploading the data.
I have datetime field in the dataset and when I use “date” type and define the format as mm/dd/yyyy hh24:mi for datetime field, I see only dates in the imported data.
When I use varchar type and use the same format mm/dd/yyyy hh24:mi then I see still see date in table data
When I try to upload using the date type and datetime format, the import fails and I get the error
"date format picture ends before converting entire input string"
what is the best way to define dttm format in Apex while uploading data?
Thanks,
Blyzz