ynab-csv icon indicating copy to clipboard operation
ynab-csv copied to clipboard

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

Open stackhaw opened this issue 7 years ago • 4 comments

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

Convert them to a standard format

stackhaw avatar Oct 20 '18 20:10 stackhaw

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 💯

aniav avatar Oct 20 '18 20:10 aniav

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.

Jessidhia avatar Jan 18 '19 13:01 Jessidhia

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

aniav avatar Jun 09 '24 18:06 aniav