search

aniav / ynab-csv

Tool for making your CSV files ready to import into YNAB
https://aniav.github.io/ynab-csv/
MIT License
164 stars 84 forks source link

Parse the dates from input CSV files so they are in the format YNAB wants #10

Open stackhaw opened 6 years ago

stackhaw commented 6 years ago

I have the date in the format: Oct 14, 2018

Convert them to a standard format

aniav commented 6 years ago

Hey @stackhaw I don't plan to do any updates on date parsing. I don't have much time to devote for this project and most date formats can be set in YNAB Budget settings so I decided to not format it at all. I see that YNAB doesn't have this format incorporated, so it doesn't really help 😢

I am willing to merge changes that would gracefully treat dates that are not within YNAB supported date formats 💯

Jessidhia commented 5 years ago

One of my banks has an interesting format which has columns, in order, for Year, Month, Day, Hour, Minute, Second, and a transaction order number for the day. Followed by the usual Payee, Outflow, Inflow stuff.

I wish my credit card export was this precise and/or useful.

aniav commented 5 months ago

@mthibode13 reported in #73:

Importing activity that comes from a MMM-DD-YYYY format; however, the converter leaves it in that format. The problem is that YNAB app does not recognize that format when importing. All of its month first options are MM.

Adding it here to keep details in one place.