Button to select date range

[#1]

I have a field ENTER_DATE and I would like a button that select all dates more then 30 days old.

Every time I work with dates I feel as though its a format issue but I can't seem to get it to work.

I created a button, select in field...

     -field: ENTER_DATE

     -search in string: <=(date(today()-30))

[Anonymous]

It may be a format issue.  But first try this:

='<=' & date(today()-30)

[#3]

Thanks for trying but that didn't seem to work either....

[Anonymous]

Works for me...  Can you upload an example?

[#5]

This is a scaled down version of what I am working on.  The dashboard has a multi date slider in it, however, our company is still fairly new to QlikView and we are facing some push back.  We are being told that the slider is not intuitive and they want a button... hence my question!

Thanks for your help

[Anonymous · Accepted solution]

I see...

The mistake is in the field name.  Don't use "=" sign

=[Enter Date]

It should be simple

[Enter Date]

or even simpler

Enter Date

Next, doesn't look like a problem but safe to do, make sure that the format of the date in action is the same as in the field:

='<=' & date(today()-30, 'MM/DD/YYYY')

Regards,

Michael

[#7]

Ahh Ha! I love simple solutions!

Thanks for taking the time to help me out!