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
