When opening a result grid that contains datetime fields, the datetime values appear to be exported as strings. that is, if I have a datetime value of '2014-07-08 00:00:00.000', it still says '2014-07-08 00:00:00.000' in Excel even if I apply a date FORMAT to it like 'mm/dd/yyyy'. I have to go to each value and click into it and then just press enter for Excel to reevaluate the value and make it a date time.
I don't know how much control you have with the data format, but if you can ensure that it is a Excel date/time field, that would be great. A compatible Excel format specifier would be "yyyy-mm-dd hh:mm:ss.000", otherwise it just shows the time and not the date.
Better yet would be to let me specify a default date format as I personally hardly ever use milliseconds in Excel (personally, I would use "yyyy-mm-dd hh:mm:ss" or just "yyyy-mm-dd hh:mm", in most cases). But, if you can at least ensure that all datetimes are not TEXT values, then I can at least set the format to what I want without touching every single cell.
Hi Lucas971
I don't know how much control you have with the data format, but if you can ensure that it is a Excel date/time field, that would be great. A compatible Excel format specifier would be "yyyy-mm-dd hh:mm:ss.000", otherwise it just shows the time and not the date.
Better yet would be to let me specify a default date format as I personally hardly ever use milliseconds in Excel (personally, I would use "yyyy-mm-dd hh:mm:ss" or just "yyyy-mm-dd hh:mm", in most cases). But, if you can at least ensure that all datetimes are not TEXT values, then I can at least set the format to what I want without touching every single cell.