Selecting a time period with a trigger used for "select in field"

[newqlikie]

Hello again,

after I got the perfect help from the community, I have a second problem.

Now I try to select a period beginning with a "startdate" (variable = "vMinDatum") till to an "enddate" (variable = "vMaxDatum").

I tried following:

I added a button "Auswahl"and added an action with "select in field" for my field "JARECDAT", which contains each date of my database beginning with 01.05.2009, 02.05.2009 till 27.09.2011.

I added following "Search String":

='=JARECDAT>=vMinDatum' and '=JARECDAT<=vMaxDatum'

This one is not working.

What do I do wrong?

Any ideas?

Thanks again for your help.

[#2]

hi

the expression should be : ='>=' & [vMinDatum] & '<=' & [vMaxDatum]

You can avoid using a button by adding triggers on both variables on input event

hope this helps

Gilles

[newqlikie · Accepted solution]

Hi Gilles,

thanks for your answer, but it does not work.

I found following solution:

='=JARECDAT >= vMinDatum and JARECDAT <= vMaxDatum'