I don't understand why this seems to be so hard. I am reading two different google sheets. The first one is input records from the field. The other sheet has the dates of our billing cycles with month, start date, and end date. There is a user parameter to type in month. User a tester I then only add the one month and its start and end dates. I then test the field records to read only those records that fall within the billing date. Originally I had this working when the dates were entered as parameters, but I am looking to automate the entire process and the user does not always know what the dates are for the billing cycle - therefore I want to eliminate the typed in dates and use the read dates from the spreadsheet. The user only has to type in the month.
I have a DateTime Converter right after both readers making their output in FME DateTime format. Then the tester using <= and <. None of the records are passing the test although they should. I checked the format, they have the same significant figures and are both strings. How can I filter based on the dates?
Best answer by nielsgerrits
View original