Hello, Just a quick guess: are you sure, there's a single space between the date and the day name? I've had a couple of sleepless nights over such things in the past, so it might be worth checking.
Also, I believe, those are locale dependent, but I assume your computer is set to English. If all else fails, you can always pre-process the file, but I reckon, you wanted to get away without any further magic... Regards, Dan On Sat, 22 Sep 2018 at 19:39 Todd Roth <[email protected]> wrote: > I'm trying to convert a credit card csv file to ledger and getting an > error when parsing the date. > > *The command:* > ledger -f sample.dat convert Transactions.csv --input-date-format > "%m/%d/%Y %a" > > *The Error:* > While parsing file "/Users/me/Downloads/Transactions.csv", line 1: > While parsing CSV line: > 06/21/2018 Fri,,"THE PAPER CANOE - DUCK, > NC","XXXX-XXXXXX",,,157.53,,,,,,,, > > Error: Invalid date: 06/21/2018 Fri > > > > Is the above error the result of ledger not recognizing the %a parse > parameter? Is there another --input-date-format I could use or do I need > to clean the csv file prior to importing with the standard "%m/%d/%Y" > format? > > > Thanks. > > -- > > --- > You received this message because you are subscribed to the Google Groups > "Ledger" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
