RE: Conversions for PeopleSoft input

Thanks Tom,
	The only tool that I have available is the PeopleSoft Message Monitor,
which accepts the message and runs an application engine program that only
contains the XSLT to convert the message.  All it tells me is the following:
XSLT unexpected error: Could not construct output XML.

Initially when I ran this, before trying to convert the date format, I was
getting a database error about my format.  Since I've tried to convert the date,
my messages don't seem to go that far.

Thanks for your help (knowing that the translation is valid XSLT is lot's of
help).
Bridget

-----Original Message-----
From: Passin, Tom [mailto:tpassin@xxxxxxxxxxxx]
Sent: Monday, March 10, 2003 3:18 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: RE:  Conversions for PeopleSoft input


[Shoe, Bridget]
>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
> 

You have to say what result you got and how you got it. I tried your
snippet and got the result you said you want (2003-02-06). I used
msxsl4, running in XML Cooktop.  I used as the source file -

<EndDate>02/06/2003 00:00:00</EndDate>

If you got nothing out of the transformation, that would indicate that
you are not selecting the right nodes of the document.

Cheers,

Tom P


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list