Select date intervals in list box

Chernov — Fri, 29 Nov 2013 00:32:51 GMT

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

Re: Select date intervals in list box

Chernov — Fri, 29 Nov 2013 01:07:21 GMT

we must use select in field Search string like this:

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