Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


  • 0

Function that checks time range overlaps


Neo Andersson

Question

Hello guys, i am struggling a bit to create a function that checks over a table and detects if there is any overlap between timeranges. Time ranges are represented by startime, and stoptime keys of the table.

 

Please login or register to see this code.

 

i have managed to create a function that works for majority of scenarios, but it fails for the given example above. It doesn't detect that 18:31-00:30 and 23:16-00:44 overlap. The problematic parts are when time spans over midnight i guess.  If anyone hase any idea, what approach to use for this?

Tha function should handle every possible ranges even those that span over midnigh.

 

Thanks in advance

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

there is a difference in use of 18:31..00:30 and 23:16..00:44?

If yes you can use that fa in a gv?

In the written case it will switch @23:16 to this setting

 

Link to comment
Share on other sites

  • 0
  • Inquirer
  • 1 minute ago, Sjakie said:

    there is a difference in use of 18:31..00:30 and 23:16..00:44?

    If yes you can use that fa in a gv?

    In the written case it will switch @23:16 to this setting

     

    This should be a controlling function that alerts user, if the provided ranges overlap. Nothing is triggered upon these timeranges at this point.

    I only need a function that checks if any of these pairs overlap.

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • Okay, i think i have found a solution with help of fibaroExtra fibaro.between function

     

     

    Please login or register to see this code.

     

     

    If anyone needs something similar...

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Answer this question...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...