this post was submitted on 27 Dec 2023
5 points (100.0% liked)

Plain Text Accounting

161 readers
1 users here now

Bookkeeping and accounting with plain text files and scriptable, command-line-friendly software, such as Ledger, hledger, or Beancount.

founded 1 year ago
MODERATORS
zako
5
Help with parsing this dateformat using hledger (self.plaintextaccounting)
submitted 11 months ago* (last edited 11 months ago) by PracticalReputation to c/plaintextaccounting
2 comments fedilink hide all child comments
 

I have a csv file I'd like to read, seems I'm correct other than parsing the date. The csv file shows the date like so: ""2023-03-04 07:54:33"

I've tried a bunch without success. I feel it should be:

date-format %Y-%M-%D %H:%M:%S

But nope, getting an error it can not parse it.

top 2 comments
sorted by: hot top controversial new old
[โ€“] IronyHammer 4 points 11 months ago (1 children)

You have %M as both month and minute. Double check what each individual date part is meant to be.

[โ€“] PracticalReputation 2 points 11 months ago

Thanks for pointing that out, it was one of the problems, the solution was using: date-format %Y-%m-%d %H:%M:%S

Next problem was I forgot to add skip 1 at the top.