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 )
Solved
Calculating previous dates
+8- Enthusiast
Best answer by ebygomm
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
+32- Influencer
- Best Answer
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
+8- Enthusiast
ebygomm wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.