I am looking to limit my data where PERF_END_DATE >= now and <= a year from now but I think I have a syntax error.
Here is the expression:
=if([PERF_END_DATE]= {">=$(=timestamp(now()))<=$(=timestamp(now() + 365))"},[PERF_END_DATE])
I am getting a ')' expected error. Any help would be greatly appreciated.