Statement Export - CSV Date Formatting


#1

Hi,

Its seems the date field of the CSV is only the day and month, and not including the year, as such importing to Excel and converting to a date value it incorrectly converts it.

Please can we have the Year added to the CSV output

Thansk


#2

What version of the app do you have and what system (android or iOS) do you use?

I am using v5.29 on Android 8.0 and everything seems fine.

  • However it would be nice if the date format would follow ISO 8601 (yyyy-mm-dd) Excel has a hard time detecting the date. (might be related to language)
    left column: Excel’s detected format, right column: raw data (csv in notepad)
    image

  • Excel also doesn’t like the preformatted balance, e.g. 1,234.56. Please strip that comma.

  • Remove leading and trailing blanks from the field values.


#3

Using iOS - latest version

It seems its not showing the current year, only previous:


#4

Did you open it in a text editor?
This might be due to Excel’s auto format.
Home tab -> Number group -> dropdown select short date