Viewer should accept DD/MM/YYYY format

07-26-2011 11:32 AM
Status: Open
New Contributor II

The July 2011 update for Viewerhas the ability to import CSV files by dragging and dropping to the viewer. Our CSV file has a "field" referred to date and the format for this like DD/MM/YYYY. After importing this file, the viewer show for all tabular data weird dates like for 2012 or 2013 (all dates on CSV file are from 2011). After changing to a MM/DD/YYYY format all works as expected. However this was a manual change of some sample records and the original CSV file comes from exporting a large database where the date format is DD/MM/YYYY. So we hope in the future consider to auto-recognize this format for all the rest of the world that use the dates in this way. Same with Exlorer Online. Thanks.