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.
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
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