Skip to main content

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