Question
I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.
+1- Contributor
- 10 replies
I need to filter by date. Its a CSV: that I need to filter by both Open and Closed status. But I need to find the Closed work orders that have been closed in the last 60 days. I am using TESTER to do the filter.
+31- Influencer
- 627 replies
You should be able to use this expression in a Tester or TestFilter.
@DateTimeFormat(@Value(date_field),%Y%m%d) >= @DateTimeAdd(@DateTimeFormat(@DateTimeNow(),%Y%m%d),-P60D)