Question

  • Creator
    Topic
  • #2209469

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

    Locked

    by 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?




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

    Thanks

    Simon

All Answers

  • Author
    Replies
    • #2444646

      Clarifications

      by simonp093 ·

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

      Clarifications

    • #2444535

      What’s your date/time format?

      by seotools ·

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

      What’s your time format? You could simply use [url=http://www.w3.org/TR/xpath/#function-substring]substring function[/url] for both fields to get the seconds, then subtract them and check if they’re < 5

      • #2444465

        Reponse To Answer

        by simonp093 ·

        In reply to What’s your date/time format?

        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

Viewing 1 reply thread