[Bug]: Date parser in csv import confuses between two formats

[ishanjain28]

Verified issue does not already exist?

• I have searched and found no existing issue

Is this related to GoCardless, Simplefin or another bank-sync provider?

• I have checked my server logs and could not see any errors there
• I will be attaching my server logs to this issue
• I will be attaching my client-side (browser) logs to this issue
• I understand that this issue will be automatically closed if insufficient information is provided

What happened?

My bank generates CSV files which use DD/MM/YY format. I have set Date format to DD/MM/YY in AB and it is still parsing them as MM/DD/YY.

A redacted csv file that can be used to replicate this bug.

  Date
 01/01/24
 03/01/24
 10/01/24
 19/01/24
 19/01/24
 21/01/24
 01/02/24
 01/02/24
 01/02/24

What error did you receive?

There are no errors, It parses the input incorrectly.

Where are you hosting Actual?

Locally via Yarn

What browsers are you seeing the problem on?

Firefox

Operating System

Linux

[pprimor]

I'm not sure what the issue is here. Did you try importing the transactions to see if the dates were, in fact, wrongly parsed?

Keep in mind that, in the screenshot you posted, the parsed dates are in the format MM/DD/YYYY. This is the default for the app but you can change it anytime in the settings.

[ishanjain28]

Thank you @pprimor That was it!

I didn't realize I had to change date to dd/mm/yy in more -> settings.

It works perfectly after changing date in settings.