Date format for bank reconciliation bank statement import

(0) Share

Report

Posted on by CU13010319-0

496

I have a CSV file here to upload for a bank account reconciliation for the bank statement entries. Most of the time the date has been in format MM-DD-YYYY, so i have been able to configure the data exchange definition and import with no issue. However, the current file I have the date is in format DD-MM-YYYY, so I receive an error when importing the CSV: the value in line 1, column 4 has incorrect format or type. Expected format: date, according to the data format and data formatting culture of the data exch column def. Actual value "01-12-2025".

I have tried both types of text and date, as well as using the transformation rule for US_date_format. Any suggestions, on the data exchange, transformation rule or elsewhere to be able to read the date correctly? I do not want to manually edit the date on the CSV as there are too many lines to do so

I have the same question (0)