Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am currently putting together a document where the user needs to be able to select a range of dates and then be able to toggle on a seperate value to be included. The range selection works fine using triggers for Min/Max vars but when I try include an extra single value I am unsure how to make it filter properly.
Field = Expiration Year
Range Select in Field example: >=2013<=2015
The data also includes the value 'MTM' so I need to be able to include that in the dataset based on toggling a button.
Can I modify the filter string to include this value AND the range? I have tried varius combinations but can't figure it out. Or can I make the trigger put the values as 2013,2014,2015,MTM instead of the range example above?
Thanks in advance
I figured it out.
This worked: =if(MTM=1,'(') & '>=' & minExpYr & '<=' & maxExpYr & if(MTM=1, '| MTM)')
(MTM being the button varible to toggle on/off)
Final Select in field criteria shows as: Expiration Year: (>=2013<=2015| MTM)
The brackets were the issue, I was not including them.
I figured it out.
This worked: =if(MTM=1,'(') & '>=' & minExpYr & '<=' & maxExpYr & if(MTM=1, '| MTM)')
(MTM being the button varible to toggle on/off)
Final Select in field criteria shows as: Expiration Year: (>=2013<=2015| MTM)
The brackets were the issue, I was not including them.