Skip to main content
  • EN

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

Hi @mr_fme,

I think the simplest way to do this would be to

  1. Use the DateTimeCalculator to create an attribute that stores the date 7 days ago
  2. 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.

datetest.fmw

Hi @mr_fme,

I think the simplest way to do this would be to

  1. Use the DateTimeCalculator to create an attribute that stores the date 7 days ago
  2. 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.

datetest.fmw

I´m glad!

Thank´s @hollyatsafe

Reply


Community Stats

30,366
Posts
115,373
Replies
38,143
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.