02-06-2014 02:43 AM
Hi All ,
Please go through the attached screen shot and let me know why the date format is varying from each other on the same report.
Thanks in advance
02-06-2014 05:17 AM
02-06-2014 05:36 AM
02-06-2014 11:07 AM
Yeah, it looks like Excel is formatting the dates differently. I typically format the cells as category: text (highlight column, right click, format cell) to avoid any interference from Excel trying to predict the data format.
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
02-18-2014 10:10 PM
we got following reply from Aruba support.
Tested few reports in our lab, the date and time values in “Connect Time” and “Disconnect Time” are getting shuffled. When we run the report to export that to a CSV file, the information is fetched from Airwave Database and the transfer of data to the csv file is based on how the data is stored in database. It is the expected behavior that the values can get shuffled based on how it is stored in Airwave Database. Once we have the complete data available on the csv file, the only option to sort this is from csv file in ascending or descending order.