I need to create a button that when when clicked will set the Date to a specified range (range is calculated by an expression)
The problem the set range is not working.
Setting date >= X works [Expression is ='<='&v.Date.Enddate]
Setting date <= X works [expression is ='>='&v.Date.Startdate]
Setting date >= X AND <= X Does NOT Work [Expression is =('>='&v.Date.Startdate&' AND <='&v.Date.Enddate)]
I am using a Button object, Action 'Select in Field'
Thanks for your suggestion unfortunately neither return any results.
using =('>='&v.Date.Startdate&' AND <='&v.Date.Enddate) the end date of 31/07/2017 does seem to get applied but no the start date, If I switch the dates around so the expression is =('<='&v.Date.MAT.Enddate&' AND >='&v.Date.MAT.Startdate) then the Start date of 01/08/2016 is applied but not the end date.
It's like it's only applying the expression part after the AND..?!?