How to fix datasphere DATE format for CSV file going to LOCAL TABLE

[Loed]

Hi,

I do have a lot of flat files to be uploaded in a LOCAL TABLE. The problem is some of the fields were defined as DATE but the date format in the CSV files were in the format MM/DD/YYYY.

How do you fix this error aside from manually editing the DATE fields based on the suggested format such YYYY-MM-DD?

Thanks.

Loed

[Vitaliy-R]

I do not know the full context, but it is quite common to define date format as a string, and then do convertion of dates into the date format in the next step, if possible. Regards.