github-starred/actual
2
0
Fork 0
mirror of https://github.com/actualbudget/actual.git synced 2026-03-22 00:13:45 -05:00
Code Issues 250 Packages Projects Releases 53 Wiki Activity

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

New Issue
Closed
opened 2026-02-28 19:24:35 -06:00 by GiteaMirror · 2 comments
GiteaMirror commented 2026-02-28 19:24:35 -06:00
Owner
Copy Link

Originally created by @ishanjain28 on GitHub (Feb 1, 2024).

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.

image

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

Originally created by @ishanjain28 on GitHub (Feb 1, 2024). ### Verified issue does not already exist? - [X] I have searched and found no existing issue ### Is this related to GoCardless, Simplefin or another bank-sync provider? - [X] 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 - [X] 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. ![image](https://github.com/actualbudget/actual/assets/7921368/d0a36a99-5113-4405-a566-223ee104b1d2) 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
GiteaMirror added the bug label 2026-02-28 19:24:35 -06:00
GiteaMirror commented 2026-02-28 19:24:35 -06:00
Author
Owner
Copy Link

@pprimor commented on GitHub (Feb 2, 2024):

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.

Screenshot 2024-02-02 at 10 21 38
@pprimor commented on GitHub (Feb 2, 2024): 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. <img width="545" alt="Screenshot 2024-02-02 at 10 21 38" src="https://github.com/actualbudget/actual/assets/32823033/342aea01-382b-4952-b2b1-1d75a31693a1">
GiteaMirror commented 2026-02-28 19:24:36 -06:00
Author
Owner
Copy Link

@ishanjain28 commented on GitHub (Feb 2, 2024):

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.
image

@ishanjain28 commented on GitHub (Feb 2, 2024): 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. ![image](https://github.com/actualbudget/actual/assets/7921368/fc46e6c3-3d2a-4689-b8ba-1f136c938b79)
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
AI generated
API
bank sync
budgeting
bug
can’t replicate
dependencies
docker
documentation
electron
experimental feature
feature
feedback
goal templates
good first issue
help wanted
importers
maintenance
needs info
needs testing
needs triage
needs votes
openid
payees
pull-request
Mirrored from GitHub Pull Request
 regression
reports
responsive
rules
schedules
server
✨ merged
split transactions
tech debt
theme
transaction import
transaction reconciliation
transactions
translations
upstream
user interface
✅ approved
wontfix
No Label bug
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/actual#904
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?