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])))))