Imported expenses, incorrect dates

Self-Hosted | v4/Legacy
1

Hi Support,

I’m setting up my Invoice Ninja account (invoiceninja.com) and I imported my expenses from a CSV file.

It imported but I’ve noticed that all the dates are wrong.

The format of the CSV was like this:

Date Description Money Out
11/05/2018 CARD PAYMENT TO CompanyName,6.95 GBP ON 09-05-2018 £ 6.95

But the date is going into your system as 05/Nov/2018

Any idea what went wrong and how to fix it, other than manually doing it?

Thanks

2

I think the problem is the date format: 11/05/2018

I’d suggest fixing it in the spreadsheet, purging your data on Settings > Account Management and then reimporting it.

3

Thanks.

What should the date format be?

4

YYYY-MM-DD is best

1 Like
5

Thanks, that worked.

6

Great to hear, thanks for letting us know!

7

This helped me out too - couldn’t understand why random columns were being given today’s date … but this format tip solved it.