No announcement yet.

DateTime order

  • Filter
  • Time
  • Show
Clear All
new posts

    DateTime order

    I am trying to sort my motion detectors in the status display in date/time of the last change order. I set the device string to strdevicelastchange ( date time) in the file, but the displayed order is not chrolological. If I set the string to idevicetime (minutes since last change) the order is OK, but it is limited to whole minutes and makes determining the direction of movement difficult.
    Is there a way to sort the on the strldevicelastchange value in chronolical order?
    The format is '2/4/2005 10:50:39 PM'
    I am using- sort select="STRING" data-type = "number" order="descending"

    <xsl:for-each select="DEVICE">
    <xsl:sort select="STRING" data-type = "number" order="descending" />
    <xsl:if test="TYPE = 'MS13A (Hawkeye II)'or LOCATION = 'Joist'">
    <td class="tableroweven" width="45%" valign="top" align="left">
    <xsl:value-of select="NAME" />
    <td class="tablerowodd" width="10%" valign="top" align="left">
    <xsl:apply-templates select="ICON
    <td class="tableroweven" width="45%" valign="top" align="left">
    <xsl:apply-templates select="STRING" />

    All fixed, fat fingered the case on the "STRING" value. It's amazing how many times I could do that in a row!