Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
isciberras
Creator
Creator

When creating a button is it possible to set date greater than specific date?

Hi All,

I created a text object with an action of "Select in field" and all I want to do is set  a date greater than 08/05/2016. I set the field name which contains the date.


In the search string section I just put  >08/05/2016 however this doesn't seem to work. If I write = instead of > the button works fine.


Does anyone know how I can fix this?

Thanks,

Isaac

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Try this

='>08/05/2016'

View solution in original post

7 Replies
Anil_Babu_Samineni

Perhaps this?

='>' & Date(MakeDate(2016,05,08),'dd-MMM-yyyy')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
antoniotiman
Master III
Master III

Try this

='>08/05/2016'

Anonymous
Not applicable

Try this:

='>=08/05/2016'

isciberras
Creator
Creator
Author

Thank you very much for your help unfortunately this didn't work.

isciberras
Creator
Creator
Author

Thanks

isciberras
Creator
Creator
Author

Worked brilliantly thank you

Anil_Babu_Samineni

Normally, should work. But Format of date issue

='>' & Date(MakeDate(2016,05,08),'DD-MM-YYYY')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful