Hi all,
I have an excel file with several lines. I have a data field and countries, I need to validate which countries have less than 1 line with data between the last 7 days or the week before, How could I do that?
Thank you
Solved
Validate previous date in excel file
+9- Enthusiast
Best answer by hollyatsafe
Hi @mr_fme,
I think the simplest way to do this would be to
- Use the DateTimeCalculator to create an attribute that stores the date 7 days ago
- Use a Tester to see if the date recorded for each country is greater than or equal to that date. This should work nicely as the Tester has a Comparison Mode for Date/Time.
Any features that pass the tester, fall within the last 7 days. Please find attached a workspace to demonstrate my idea.
Hi @mr_fme,
I think the simplest way to do this would be to
- Use the DateTimeCalculator to create an attribute that stores the date 7 days ago
- Use a Tester to see if the date recorded for each country is greater than or equal to that date. This should work nicely as the Tester has a Comparison Mode for Date/Time.
Any features that pass the tester, fall within the last 7 days. Please find attached a workspace to demonstrate my idea.
+9- Enthusiast
hollyatsafe wrote:
Hi @mr_fme,
I think the simplest way to do this would be to
- Use the DateTimeCalculator to create an attribute that stores the date 7 days ago
- Use a Tester to see if the date recorded for each country is greater than or equal to that date. This should work nicely as the Tester has a Comparison Mode for Date/Time.
Any features that pass the tester, fall within the last 7 days. Please find attached a workspace to demonstrate my idea.
I´m glad!
Thank´s @hollyatsafe
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.