I am uploading a csv file with a cdate type column, I changed the format in the csv to be "yyyy-mm-dd" which coincides with the format shown in cloud database. However when I upload it the column with date is not uploading correctly.
The rest of the columns are OK except for that one.
Any help would be useful.
Thanks!
Discussion posts and replies are publicly visible
I suggest to do a two-step approach. First import the excel into a text only table. Then run a stored procedure to transform the data into the final table.