I want to filter my records by last modified date and i want to bring only last 90 days of data to be brought in my data set. I dont want to use the compute node since compute process very costly. I want to achive this with filter transformation node itself. For example i tried using 'lastModifiedDate':EQ:LAST 90 DAYS or 'lastModifiedDate':EQ:LAST_90_DAYS. But both didn't work. Any help is much appreciated.
As you mentioned in your post it can be done using compute expression, since it may cost you the performance of the dataflow. You don't want to implement it that way.
My suggestion here would be create a formula field with checkbox return type. use the SOQL LAST_N_Days:90 function to check whether your record's last modified date lies in past 90 days or not.
filter Expression Documentation does not suggest that relative date filters are supported. In fact, the filter transformation seems rather limited:
- Not Equals/NOT IN:
- In range:
- Greater or equal:
- Less or equal:
R::val0- note double colon
- AND condition: join statements with comma
There is no
OR support. And equals/not equals filters compare text arguments.