Skip to main content
  • EN

I have a table that has almost 1000 rows, but these rows have a date field. I need to make a filter, which I can only use from today's date the previous 3 days ... however, I have some doubts on how to do a subtraction for example if today is 01/4/2021 (mm / dd / yyyy )

I would format your dates into FME format with a DateTimeConverter then in a tester you can test for if the Date is greater than the DateTimeNow minus 3 days (-P3D). Note that the comparison mode in the tester is set to Date/Time

Capture

I would format your dates into FME format with a DateTimeConverter then in a tester you can test for if the Date is greater than the DateTimeNow minus 3 days (-P3D). Note that the comparison mode in the tester is set to Date/Time

Capture

Thank´s for your attention

Reply


Community Stats

30,162
Posts
114,508
Replies
37,819
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.