Subject: Re: [xsl] Conversions for PeopleSoft input From: David N Bertoni/Cambridge/IBM <david_n_bertoni@xxxxxxxxxx> Date: Mon, 10 Mar 2003 12:08:42 -0800 |
> Hi, > Can someone tell me why this does not work? I am trying > to convert the date from a Siebel format to a PeopleSoft format. > > Input data is date in format: MM/DD/YYYY HH:MM:SS > i.e: 02/06/2003 00:00:00 > > I need the output as YYYY-MM-DD > > XSLT that I am trying to use to transform this is: > > <QUOTE_DUE_DATE><xsl:value-of select="concat(substring(EndDate, 7, 4), '-', > substring(EndDate, 1, 2), '-', substring(EndDate, 4, 2))"/> > </QUOTE_DUE_DATE> It would help if you gave us more information. For example, what does the input data look like? Is EndDate an element in the input XML, does it contain the correct string, and is it a child of the current node? Or perhaps EndDate is a variable, and you simply forgot the '$' character? <QUOTE_DUE_DATE> <xsl:value-of select="concat(substring($EndDate, 7, 4), '-', substring($EndDate, 1, 2), '-', substring($EndDate, 4, 2))"/> </QUOTE_DUE_DATE> Dave XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Conversions for PeopleSoft in, Shoe, Bridget | Thread | RE: [xsl] Conversions for PeopleSof, Passin, Tom |
RE: [xsl] Get Position of Node in A, Michael Kay | Date | RE: [xsl] XPATH simple question, Michael Kay |
Month |