1 Reply Latest reply: Nov 28, 2013 8:07 PM by Stanislav Chernov RSS

    Select date intervals in list box

    Stanislav Chernov

      Hi everyone,

      i have table with dates, interval from 01.01.2012 to 31.12.2013,

      i added 2 - variables on sheet - vStart1 , vEnd1, in this var's i put dates like this:

      vStart1 = 01.10.2013

      vEnd1 = 05.10.2013

       

       

      i want by button click, interval of my var dates has apply to listbox

      in result i want see selected dates in listbox : 01.10.2013 ,02.10.2013, 03.10.2013, 04.10.2013, 05.10.2013

       

       

      in searchbox on my lisbox i can use only one condition like this >=01.10.2013 and it work's, question: how i can use second condition ?

       

       

      construction not worked i've tested in

      action - 'select in field' by button click:

      = >=vStart1 & ' | ' & <= vEnd1

      = '>=vStart1' & ' | ' & '<= vEnd1'

      = (>=$(vStart1) & ' | ' & <= $(vEnd1))

       

       

      construction not worked i've tested in

      search field in lisbox :

       

       

      >= 01.10.2013 & <= 05.10.2013

      >= 01.10.2013 | <= 05.10.2013

      >= 01.10.2013 || <= 05.10.2013

      '>= 01.10.2013' | '<= 05.10.2013'

      >= '01.10.2013' | <= '05.10.2013'

      and many other's