Times in reports are not Excel compliant
Hi
The problem I am having at the moment is since upgrading to SD+ 7.6 (build 7601), when creating reports, fields like Request Created time and Completed time are no longer in an Excel friendly format.
Previously they would be written as such:
27/11/2009 14:34
Which, when exported to Excel, Excel understood as a date and time.
Nov 27, 2009 2:34 PM
Which Excel treats as text, so we can't do any operations on it.
I've looked through all the settings, but I can't find an option to have dates/times displayed as they were previously.
Any help would be greatly appreciated.
Thanks