Add a date format setting for exports from lists

When exporting from lists the dates are exported in mm/dd/yyyy format which aren't interpreted correctly by Excel when you're using a language that is expecting them in dd/mm/yyyy format (some get imported as text because they aren't valid dd/mm/yyyy dates and potentially worse others do get turned into dates but with the day and the month the wrong way round). There are workarounds for this such as the ones listed here: https://www.archibus.com/ai/abizfiles/v21.1_help/archibus_help/Subsystems/smart_client/Content/fim/managing_wc/data_transfer/csv_files_and_excel.htm but it would great if there was a setting for the date formats for exports so that the CSV files can just be loaded into Excel directly.

  • James Hudson
  • Feb 9 2018
  • Attach files