Questions

How do I check if a time field is within 5 seconds of another in XSL?

Tags:
+
0 Votes
Locked

How do I check if a time field is within 5 seconds of another in XSL?

SimonP093
I have an interface between two pieces of software with Stylesheets between to transform and also validate certain data. A requirement has been altered so that rather than just checking two fields are equal before selecting, I now require a test where they are equal or no more the 5 seconds greater?

<xsl:template match="DATA">
<xsl:apply-templates select=" SWOR/SWOL[TSTAMP = $exportdatetime and CMPRDT]"/>
<xsl:call-template name="trailer"/>
</xsl:template>

If anyone has a solution to this I would love to know about it.

Thanks

Simon
  • +
    0 Votes
    seotools

    What's your time format? You could simply use substring function for both fields to get the seconds, then subtract them and check if they're < 5

    +
    0 Votes
    SimonP093

    Thanks for the update. Initially the field is a full Date:Time field YYYYMMDD HH:MM:SS

    the issue is if the seconds are likely to be near the full minute i.e. 58 secs. As then the result will be wrong if just using greater than. I was hoping for a function where I could set a second variable that was based on the Date:Time given plus 5 seconds and then to a comparison?

    Is this possible?

    Thanks again for your response so far.

    Simon

  • +
    0 Votes
    seotools

    What's your time format? You could simply use substring function for both fields to get the seconds, then subtract them and check if they're < 5

    +
    0 Votes
    SimonP093

    Thanks for the update. Initially the field is a full Date:Time field YYYYMMDD HH:MM:SS

    the issue is if the seconds are likely to be near the full minute i.e. 58 secs. As then the result will be wrong if just using greater than. I was hoping for a function where I could set a second variable that was based on the Date:Time given plus 5 seconds and then to a comparison?

    Is this possible?

    Thanks again for your response so far.

    Simon