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?
Solved! Go to Solution.
='>' & Date(MakeDate(2016,05,08),'dd-MMM-yyyy')
Normally, should work. But Format of date issue
='>' & Date(MakeDate(2016,05,08),'DD-MM-YYYY')