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
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