Date format problem

Question

Hello all,

While exporting from sharepoint list data to excel , I am getting strange date format values

"10/30/2012 " --correct format (its from sp list)

"2012-10-30T05:00:00Z"--incorrect format(its from exported excel sheet)

I need to get correct format as I mentioned above any idea?

---

Like Cricket

Answer 1

Hi.

If the date column in the SharePoint list is of the format Date & Time then this is expected behaviour. If so, try changing it to Date Only.

If not, try to fix it in excel, data > text to columns > delimited > other, 'T'

That works for me on your content.

Regards

---

Thomas Balkeståhl - Technical Specialist - SharePoint - http://blog.blksthl.com
Download the SharePoint Branding Project here

Answer 2

use

SPUtility CreateDateTimeFromISO8601DateTimeString

http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.utilities.sputility.createdatetimefromiso8601datetimestring.aspx

---

Manish Sati