<center></center>Hi,

I'm new to XML and XSL transformations. I have output from one system that has the dates as DD/MM/YYYY and they did need to be transformed so that the import to another system is in this format DD/MM/YY. Can someone please help in what code I should use as well as where to put it? Thank you so much. Kind Regards, Tracy

Try:

<xsl:template match="date-element">
  <xsl:copy>
    <xsl:value-of select="concat(substring(., 1, 6), substring(., 9, 2))"/>
  </xsl:copy>
</xsl:template>

If this is the only change to be made to the input document, write a stylesheet that contains the above rule (with the element name changed, of course) plus a default rule that copies other elements unchanged:

<xsl:template match="*">
  <xsl:copy>
  <xsl:copy-of select="@"*/>
  <xsl:apply-templates/>
  </xsl:copy>
</xsl:template>

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi Michael, Thank you so much for your reply. Here's part of the XSL file and one of date fields.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:template match="/">
    <Batch>
  <ResultsSummary>
    <ExtractCount>5</ExtractCount>
    <ErrorCount>0</ErrorCount>
      </ResultsSummary>
       <ExtractedFrom>
    <BusinessContext>Telco</BusinessContext>
    <RootDataFolder>Marketing Automation\Business Contexts\Telco\Data</RootDataFolder>
  </ExtractedFrom>
    <LogicalUnit>
        <CampaignDO>
            <Name><xsl:value-of select="/AprimoXMLPublishing/DataObjects/Object/ResultData/name" /></Name>
            <Code><xsl:value-of select="/AprimoXMLPublishing/DataObjects/Object/ResultData/campaign_code/value" /></Code>
            <Description><xsl:value-of select="/AprimoXMLPublishing/DataObjects/Object/ResultData/description" /></Description>
            <DateModified><xsl:value-of select="/AprimoXMLPublishing/DataObjects/Object/ResultData/modified_date" /></DateModified>
            <DateCreated><xsl:value-of select="/AprimoXMLPublishing/DataObjects/Object/ResultData/modified_date" /></DateCreated>
            <Owner>SAS Demo User</Owner>
            <ModifiedUser>SAS Demo User</ModifiedUser>
            <Shared>true</Shared>
            <HasDiagram>false</HasDiagram>
            <HasCells>false</HasCells>
            <HasAudience>false</HasAudience>
            <HasCommunications>false</HasCommunications>
            <HasCellRefs>false</HasCellRefs>
            <Saved>true</Saved>

Are you saying I change date-element to be modified_date but place in another file? Or can I just use the sxl:value command to change it?

Kind Regards,

Tracy

You asked where the code should go and I had no idea of the context so I guessed you were doing a transformation in which this was the only change being made. I guessed wrong.

Just put the xsl:value-of expression in the place where you are constructing the modified date, changing "." to an expression that fetches the original date to be modified.

Since many of the fields of CampaignDO come from one element deep in the source document, I would do an apply-templates to that element and put this logic in a separate template rule.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thank you Michael.
Final conumdrum I have.

DD/MM/YYYY 12:00:00 AM needs to be converted to DD/MM/YY 12:00 AM

Because some of the dates are 7/12/2006 and then 10/12/2006 the position may change. Is there a way for it to take i.e. all chars before / or all chars after / or a xsl function that will search for / and return it's location. Thanks, Tracy

Kind Regards,
Tracy

>DD/MM/YYYY 12:00:00 AM needs to be converted to DD/MM/YY 12:00 AM

This one can be handled using exactly the same kind of concat/substring logic as the previous problem

>Because some of the dates are 7/12/2006 and then 10/12/2006 the position may change.

This makes it more difficult. In XSLT 2.0 you can use regular expressions to analyse the strings. In 1.0, you're confined to a more limited set of functions such as substring-before and substring-after. It's tedious, for example to extract the second component you have to do

substring-before(substring-after(., '/'), '/')

but it's still possible. You can use format-number() to force a number to exactly two digits.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference