RE: [xsl] Conversions for PeopleSoft input

["Michael Kay" <mhk@xxxxxxxxx>]

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.H.Kay@xxxxxxxxxxxx
work: Michael.Kay@xxxxxxxxxxxxxx 

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of 
> Shoe, Bridget
> Sent: 10 March 2003 20:46
> To: 'xsl-list@xxxxxxxxxxxxxxxxxxxxxx'
> 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@xxxxxxxxxx]
> Sent: Monday, March 10, 
> 2003 3:09 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> 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