0 Replies Latest reply: Jun 20, 2016 3:57 AM by lingling Guo RSS

    Filter pane with expression

    lingling Guo

      Hi everyone,

       

      I am trying to put this in filter pane, but it seems to have error, please help me:

       

       

      if(GetFieldSelections(Period)='3 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),3), 'D/M/YYYY'))"}

      if(GetFieldSelections(Period)='6 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),6), 'D/M/YYYY'))"}

      if(GetFieldSelections(Period)='9 Mths',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),9), 'D/M/YYYY'))"}

      if(GetFieldSelections(Period)='1 Yr',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),12), 'D/M/YYYY'))"}

      if(GetFieldSelections(Period)='2 Yrs',[Start Date] = {"$(='>=' & Date(today(2), 'D/M/YYYY') &'<=' & Date(AddMonths(today(2),24), 'D/M/YYYY'))"}, [Start Date])))))