Dates mismatch from the value in the AllItems.aspx and the value in the Data form Webpart

Question

Hi,

I am facing a strange issue.

I am having data in a WSS 3.0 SharePoint list.

I have a column [Event Date] of type "Date & Time". I have an item with the value in [Event Date] as "10/10/2009 10:00 AM"

I am able to view the same value in the page "AllItems.aspx".

I opened the list in the SharePoint Designer [SPD].

I copied the "AllItems.aspx" and pasted it to create a new page called "AllItems_Copy(1).aspx".

I open the "AllItems_Copy(1).aspx" in the SPD. I right click the DataView Webpart in the Dign mode and select "Convert to XSLT DataView".

When i open the "AllItems_Copy(1).aspx" and "AllItems.aspx" pages in the browser, i find that the date in "AllItems_Copy(1).aspx" is "10/10/2009 6:00 AM"

I didn't perform any other activity other than the above nor did i touch anything in the code in the SPD.

Has anybody faced this issue? Kindly share your thoughts.

---

Raghavan

Answer 1

Please check the [Event Date] field of your XSLT DataView in "AllItems_Copy(1).aspx", it may be formatted as text. Change the field format to DateTime would solve the issue. 

Answer 2

Hi GuYuming,

I had tried that as well. Still the same. I had tried all formats of the date in the XSLT

---

Raghavan

Answer 3

Can you paste the xsl for the Event Date from your DVWP here?  My guess is that the four hour difference is the offset from GMT to your location.  You may have a mismatch between the time settings on your setver and SharePoint.

M.

---

Marc D Anderson - Sympraxis Consulting LLC - Marc D Anderson's Blog - @sympmarc - jQuery Library for SharePoint Web Services