In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due). The calculation is =[Created]+7. I'm trying to display this data on a page using a DVWP. But first, for testing purposes, I also
created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created].
In the List View from within SharePoint, the dates show as expected (for example):
Created = 8/12/2010 3:45 PM
Due = 8/19/2010 3:45 PM
TestCreate = 8/12/2010 3:45 PM
In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt). I see the time displayed for the example list item as:
Created = 8/12/2010 3:45:30 PM
Due = 8/19/2010 10:45:00 AM
TestCreate = 8/12/2010 10:45:00 AM
I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds). It seems like the DVWP is returning the date in a different time zone (with no seconds). The lcid is set right (1033).
I didn't see any time zone settings for the DVWP specifically. I'm basically stuck. Could someone help me figure this one out.
View Complete Post