Skip to main content
X
xabieru1831
September 22, 2023
Question

Date

  • September 22, 2023
  • 1 reply
  • 0 views

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!

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    September 22, 2023

    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.

      Terms & ConditionsAccessibility statement