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)
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.