Solved

Validate previous date in excel file

mr_fme
Rank
Badge +6

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

icon

Best answer by hollyatsafe 26 May 2020, 22:11

View original
1 Attachment

2 replies

H
Badge +2

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

mr_fme
Rank
Badge +6

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

28,709
Posts
109,481
Replies
36,554
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.