Using XSL to format a date. I'm soooo lost.

Forum|Forum|20 years ago
April 13, 2006
4 replies
626 views

Hello,

I'm using XSL to format a large XML set I get from a webservice. So far it's been working great but I need to format the date so that is looks something like this: Sunday 05/21/2006 8:00 PM
rather than this: 2006-05-21T20:00:00.0000000-04:00

I know you can format dates in the XSL but I have no idea how and all the info I can find on the net is for XSL savvy people. Which I am not.

Any help would be greatly appreciated.
Here's what I have as an xsl.
Note that eventDate is the param I need to format.

Advanced techniques

This topic has been closed for replies.

Correct answer

If <xsl:value-of select='eventDate'/> is currently returning 2006-05-21T20:00:00.0000000-04:00

Then in the substring calls replacing the "." with "eventDate" should do it.

A

Anonymous

Correct answer

If <xsl:value-of select='eventDate'/> is currently returning 2006-05-21T20:00:00.0000000-04:00

Then in the substring calls replacing the "." with "eventDate" should do it.

M

mr. modusAuthor

Inspiring

Thanks so much TCloney. Works great.

You don't happen to know how to to do alternating row color do you?
The CF equivalent would be IIF(currentRow MOD 2....

A

Anonymous

This would seem to work

<xsl:element name="formatted_date">
<xsl:value-of select="substring(., 6, 2)"/>
<xsl:text>/</xsl:text>
<xsl:value-of select="substring(., 9, 2)"/>
<xsl:text>/</xsl:text>
<xsl:value-of select="substring(., 1, 4)"/>
<xsl:text> </xsl:text>
<xsl:if test="substring(., 12, 2) < 13">
<xsl:value-of select="substring(., 12, 2)"/>
<xsl:text>:</xsl:text>
<xsl:value-of select="substring(., 15, 2)"/>
<xsl:text> AM</xsl:text>
</xsl:if>
<xsl:if test="substring(., 12, 2) > 12">
<xsl:if test="substring(., 12, 2) > 21">
<xsl:value-of select="number(substring(., 12, 2)) - 12"/>
</xsl:if>
<xsl:if test="substring(., 12, 2) < 22">
<xsl:text>0</xsl:text><xsl:value-of select="number(substring(., 12, 2)) - 12"/>
</xsl:if>
<xsl:text>:</xsl:text>
<xsl:value-of select="substring(., 15, 2)"/>
<xsl:text> PM</xsl:text>
</xsl:if>
</xsl:element>

M

mr. modusAuthor

Inspiring

Thanks for the reply. How do I get it to parse the actual eventDate value in the XML?
I pasted what you posted in place of <xsl:value-of select='eventDate'/> and I get values like:
Da/e /
Ni/e /
Ne/ Y/

What am I doing wrong? Sorry for being such a XSL newbie.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.