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 )
Page 1 / 1
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
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
ThankĀ“s for your attention
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.