asked on

Format Date Using XSL

I need to format the date in an XML Response. It is returned in the following format YYYYMMDD, and I'd like to have it display as MM/DD/YYYY.

I have the following code in place in the XSL file, and if I replace

value-of select="ms:format-date(Date, 'MMM dd, yyyy')"/

with just Date, I can get the results unformatted, but I'm apparently a bit off on my attempt to format.

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
              xmlns:ms="urn:schemas-microsoft-com:xslt"
              xmlns:dt="urn:schemas-microsoft-com:datatypes">
<xsl:template match="/">

<html>
<body>
<h2>Tracking Results</h2>
       <table width="70%" border="1" cellpadding="1" cellspacing="0" bordercolor="#FFFFFF" bgcolor="#CCCCCC">
<tr>
<th>Date</th>
<th>Time</th>
<th>Location</th>
<th>Activity</th>
</tr>
<xsl:for-each select="TrackResponse/Shipment/Package/Activity">

<tr>

       <td width="10%"><xsl:value-of select="ms:format-date(Date, 'MMM dd, yyyy')"/></td>
            <td width="10%"><xsl:value-of select="Time"/></td>
            <td width="40%"><xsl:value-of select="ActivityLocation/Address/City"/>,
            <xsl:value-of select="ActivityLocation/Address/StateProvinceCode"/>,
            <xsl:value-of select="ActivityLocation/Address/CountryCode"/></td>
            <td width="40%"><xsl:value-of select="Status/StatusType/Description"/></td>
...etc

Hopefully my explanation is clear.
Thanks in advance.

rdcpro

I think you have to use MSXML 4 for this. Make sure your progID is for the version 4 parser ("Msxml2.DomDocument.4.0").

If you can't use MSXML 4 to do this, you'll have to resort to MSXML 3, and in that case I usually just write an extension function that does what I need. Here's an example that plays around with dates:

http://dev.rdcpro.com/Members/rdcpro/snippets/filterandsort/

Chris Bayes has written an MSXSL extension that supports EXSLT:

http://www.exslt.org/date/functions/format-date/date.msxsl.xsl

Regards,
Mike Sharp

http://dev.rdcpro.com

DCfromDisplay

ASKER

Yeah, it looks like I should get away from using MSXML 4. While I'm not crystal clear on the solution after looking at your example, I hope to figure it out over the weekend.

Thanks again,

Darryl

rdcpro

oh, I meant you need to use MSXML 4, if you want the built-in IXTLRuntime format-date() function. I think it was left out of MSXML 3, but I can't say for sure.

Regards,
Mike Sharp

DCfromDisplay

ASKER

I'm afraid that I've not been able to make it work using your example. Any other suggestions would be greatly appreciated.

The problem with the MSXML 4 that I see is that I can't be sure that every client that tries to access this page will have these capabilities.

Also, here is a sample of the XML Response that I receive.

<?xml version="1.0" encoding="UTF-8"?>

<TrackResponse>
<Response>
<TransactionReference>
<XpciVersion>1.0001</XpciVersion>
</TransactionReference>
<ResponseStatusCode>1</ResponseStatusCode>
<ResponseStatusDescription>Success</ResponseStatusDescription>
</Response>
<Shipment>
<Shipper>
<ShipperNumber>12345E</ShipperNumber>
</Shipper>
<Service>
<Code>15</Code>
<Description>NDA EAM/EXP EAM</Description>
</Service>
<ShipmentIdentificationNumber>1Z123456789987654</ShipmentIdentificationNumber>
<Package>
<TrackingNumber>1Z123456789987654</TrackingNumber>
<Activity>
<ActivityLocation>
<Address>
<City>CLARKVILLE</City>
<StateProvinceCode>AK</StateProvinceCode>
<PostalCode>99901</PostalCode>
<CountryCode>US</CountryCode>
</Address>
<Code>ML</Code>
<Description>FRONT DOOR</Description>
</ActivityLocation>
<Status>
<StatusType>
<Code>D</Code>
<Description>DELIVERED</Description>
</StatusType>
<StatusCode>
<Code>FS</Code>
</StatusCode>
</Status>
<Date>20031002</Date>
<Time>135500</Time>
</Activity>

ASKER CERTIFIED SOLUTION

rdcpro

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

DCfromDisplay

ASKER

Thanks again...I think I'm well on my way now.

Darryl