Hello..
In the process of getting a date/time column to display a date in multiple formats, I found the ms:format-date and ms:format-time functions. These work except the time is defaulting to UTC time once they're formatted.
E.g. If I have the date/time entered in the form as August 16, 2012 @ 4:35pm, the default display and what is entered into the database is 2012-08-16T16:35:00-04:00.
But if I try to change the format of a date column (see below), the time of this field gets changed to UTC.
<xsl:value-of select="ms:format-date(udt:Expiration_x0020_Date, 'dddd, MMMM d, yyyy')" disable-output-escaping="yes" /> will display the proper date (Thursday, August 16, 2012) as long as it's time isn't greater then 8:00pm. So if I enter the date/time as August 16, 2012 @ 8:35pm, the formatted display date will be Friday, August 17, 2012 instead of Thursday, August 16, 2012.
Same goes for the time; if I want to custom format the time. Using the 16:35:00-04:00 entered time above:
<xsl:value-of select="ms:format-time(udt:Expiration_x0020_Date, 'hh:mm:sstt')" disable-output-escaping="yes" /> will display the time as 8:35:00pm instead of 4:35:00pm.
Anyone know how I can quit this from occurring and still allow me to format the date/time as I see fit?
Thanks..