search

system76 / beansbooks

A revolutionary cloud accounting platform designed for small and medium businesses.
129 stars 36 forks source link

Transaction import date format - allow format specification #233

Open MrJamesEllis opened 9 years ago

MrJamesEllis commented 9 years ago

Hi

My bank provides transaction downloads with a date format column in the format "dd/mm/yyyy" which is standard outside of the US. Upon import, the transactions are listed as the 5th December instead of the 12th May, for instance for a date of 12/05/2015.

Transactions which are imported as 18/05/2015 are saved with a date of 1969-12-31 instead of 18th May as I'd assume it's trying to parse a month of '18'.

I can work around this by opening the CSV in a something like LibreOffice and applying the following formula to the date column (B) then saving it and importing again.

=CONCATENATE(RIGHT(B2,4), MID(B2,4,2), LEFT(B2,2))

This ends up a column containing dates in a yyyymmdd format, which imports the dates as expected.

I thought it would be good, though, to have a date format selector when doing the import. E.g "Select date format for import or enter custom format". I could then type in dd/mm/yyyy and hit import.

Thanks!

James

funnylookinhat commented 9 years ago

That's a good idea James - thanks for the suggestion. I'll pass it along to the rest of the team.