The most likely explanation, without seeing your code, is that EndDate
is not a child of the context node at the point where you do this
computation.
Michael Kay
Software AG
home: Michael(_dot_)H(_dot_)Kay(_at_)ntlworld(_dot_)com
work: Michael(_dot_)Kay(_at_)softwareag(_dot_)com
-----Original Message-----
From: owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com] On Behalf Of
Shoe, Bridget
Sent: 10 March 2003 20:46
To: 'xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com'
Subject: RE: [xsl] Conversions for PeopleSoft input
EndDate is a element in the input. It's all very large, so
I've cut some of it out...
Input data looks like this
<?xml version="1.0"?>
<AsyncRequest>
<data PsNonXml="Yes">
<![CDATA[<SiebelMessage
MessageId=""
MessageType="Integration Object"
IntObjectName="Quote">
<SiebelQuote>
<Quote>
<QuoteNumber>1-D5G2O</QuoteNumber>
<Revision>1</Revision>
<EndDate>02/06/2003 00:00:00</EndDate>
<CurrencyCode>USD</CurrencyCode> <PaymentTerm></PaymentTerm>
<CountryofInstallation>United Kingdom</CountryofInstallation>
... Lots of additional fields/nodes <QuoteItems> <QuoteItem>
<LineNumber>1</LineNumber> <PartNumber>0074060079</PartNumber>
<ItemPrice>19.53</ItemPrice>
<Quantity>1</Quantity>
<UnitofMeasure>Each</UnitofMeasure>
</QuoteItem>
<QuoteItem>
<LineNumber>2</LineNumber>
<PartNumber>0074060079</PartNumber>
<ItemPrice>20.53</ItemPrice>
<Quantity>1</Quantity>
<UnitofMeasure>Each</UnitofMeasure>
</QuoteItem>
....
</QuoteItems>
</Quote>
</SiebelQuote>
</SiebelMessage>
]]>
</data>
</AsyncRequest>
-----Original Message-----
From: David N Bertoni/Cambridge/IBM
[mailto:david_n_bertoni(_at_)us(_dot_)ibm(_dot_)com]
Sent: Monday, March 10,
2003 3:09 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Conversions for PeopleSoft input
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
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list