I have a service that spits database data out into CSV format, that I can't necessarily change right now.
While the executing query returns the standard SQL date format -
new Date().toString(); // -> Fri Dec 26 2014 19:36:00 GMT-0800 (Pacific Standard Time)
To my dismay, Excel cannot recognize this as a date format, and I have to go at heavy lengths to chop it up into something that excel can recognize.
While i'm not too familiar with it, I know the
Custom format cell property can help in date manipulation.
What do I have to do to get Excel to recognize this date format?