Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps this?
='>' & Date(MakeDate(2016,05,08),'dd-MMM-yyyy')
Try this
='>08/05/2016'
Try this:
='>=08/05/2016'
Thank you very much for your help unfortunately this didn't work.
Thanks
Worked brilliantly thank you
Normally, should work. But Format of date issue
='>' & Date(MakeDate(2016,05,08),'DD-MM-YYYY')