Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • 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.
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.

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)

image

Reply


Community Stats

30,123
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.