Formatting a Field Containing a Time to AM/PM

taleriana · March 16th, 2004, 05:32 AM

Trying to write the XSL that displays tracking results from UPS, and I have it ALMOST done, except for one thing. In the following:

<td bgcolor="ffffff" align="center">

<xsl:value-of select="Time"/>

</td>

Time is a 6digit, 24 hour time. So 3:18:23 PM is displayed as: 151823, 4:12:01 AM would be 041201 - I WANT it to display in AM/PM (and it can ignore the seconds, no problem)... I keep looking for something "built-in" that I can just say "format this into 12-hour time" but, being new to XML and XSL, I'm not having much luck. Can someone please show me how to re-write the above to display the time in AM/PM instead of the 6-digit number it displays now?

Any help would be greatly appreciated!!

joefawcett · March 16th, 2004, 06:52 AM

Add this named template to your stylesheet:

Code:

 <xsl:template name="FormatTime">
    <xsl:param name="timeString"/>
    <xsl:variable name="hours" select="number(substring($timeString, 1, 2))"/>
    <xsl:variable name="minutes" select="number(substring($timeString, 3, 2))"/>
    <xsl:variable name="seconds" select="number(substring($timeString, 5, 2))"/>
    <xsl:variable name="indicator">
      <xsl:choose>
        <xsl:when test="$hours &gt; 11">PM</xsl:when>
        <xsl:otherwise>AM</xsl:otherwise>
      </xsl:choose>
    </xsl:variable>
    <xsl:variable name="modifiedHours">
      <xsl:choose>
        <xsl:when test="$hours = 0 or $hours = 12"><xsl:value-of select="12"/></xsl:when>        
        <xsl:otherwise><xsl:value-of select="($hours) mod 12"/></xsl:otherwise>
      </xsl:choose>
    </xsl:variable>
    <xsl:variable name="modifiedMinutes">
      <xsl:choose>
        <xsl:when test="$seconds &gt; 29"><xsl:value-of select="$minutes + 1"/></xsl:when>
        <xsl:otherwise><xsl:value-of select="$minutes"/></xsl:otherwise>
      </xsl:choose>
    </xsl:variable>
    <xsl:value-of select="concat($modifiedHours, ':', $modifiedMinutes, ' ', $indicator)"/>
  </xsl:template>

Change your existing code to this:

Code:

<td bgcolor="ffffff" align="center">

        <xsl:call-template name="FormatTime">
          <xsl:with-param name="timeString" select="Time"/>
        </xsl:call-template>

</td>

Needs to be tested:)

Joe (MVP - xml)

taleriana · March 16th, 2004, 11:10 PM

Worked Perfect! Thank you so much!!!!!

Now if I can just figure out how to take the XML data and get it into a format I can input into my database. I need like ONE field: RatingServiceSelectionResponse/RatedShipment/RatedPackage/TotalCharges/MonetaryValue