Help with parsing this dateformat using hledger

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.

5 points · 2 comments · view on lemmy.world

2 Comments

IronyHammer@lemmy.world · 4 pts · 2y (1 reply)

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

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.