Data Export exports date and time in bad format

jirikadlec2[CodePlex]
When the user's Windows regional and language settings are non-English (for example Czech), the values of the LocalDateTime and DateTimeUTC columns in the exported CSV file are in a non-standard format. This makes it difficult to work with the exported
csv file in popular tools like LibreOffice or R.

As a fix I would recommend adding an drop-down with quotDate and Time formatquot option and add two date/time format options: default (same as now for example month/day/year in the english language settings) and International date time format (yyyy-mm-dd
hh:mm:ss).

For description of international date and time format see:
http://www.cl.cam.ac.uk/~mgk25/iso-time.html

Start by locating the Data Export implementation that writes the LocalDateTime and DateTimeUTC columns, then reproduce the output with non-English Windows regional settings. Review the requested default and international formats, and verify that exported CSV files use the selected format consistently in LibreOffice or R.

Written by the indexing model from the issue text.