SSDN - Changing Date format in XLST

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Daniel Luczak

Subject: Changing Date format in XLST
Author: Daniel Luczak
Date: 13 Feb 2009 09:12 AM

Hello all -
I am new with Stylus studio-
I have Stylus Studio 2008 Rev 2
I hae created an XLST file to map a CSV to a XML file
I need to change the date format Currently the csv file give the date as 9/1/2005 month/Day/Year and I want to convert the date to Year-Month-Day

Can someone help me with what would be need to be added to XLST code to do the conversion.

I will be adding the code to the following line
<OppDecisionDate>
<xsl:value-of select="CLOSEDATE"/>
</OppDecisionDate>

If someone has an example that they can share with me that would be great

Dan

Minollo I.

Subject: Changing Date format in XLST
Author: Minollo I.
Date: 13 Feb 2009 09:35 AM

Something like this:
<xsl:value-of select="concat(substring-after(substring-after(CLOSEDATE,'/'), '/'), '/', substring-before(substring-after(CLOSEDATE,'/'), '/'), '/', substring-before(CLOSEDATE, '/'))"/>

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.