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
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
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)
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.