Auto-deleting records based on a datestamp

Different ways to solve this.

One way is to use a Tester transformer to test if the difference between the EndDate and CurrentDate is positive or negative.

@DateTimeDiff(@Value(EndDate),@DateTimeNow(),days)

Records that need to be moved need to be inserted into the historics table and need to be deleted from the actual layer.

But the easier route would be to use one table as source in QGIS but add it as two different layers and use the Filter functionaliity to display only the actual features in actual and the historical features in historical.

Thanks for tht, nielsgerrits .

And would the date values need to be in a certain format (datestamp, American date format etc.)? And would the attribute type need to be ‘date’ or would character be OK?

nielsgerrits ​​​​​regarding your first option, where in the Filter does @DateTimeDiff(@Value(EndDate),@DateTimeNow(),days) go? I assuming it’s one of the Test Clauses? Do I set up one test clause or two?

nielsgerrits ​​​, I’ve tried End date > @DateTimeNow()​​

But that sends the four records to the Failed port. I was hoping it would send the two records where end date is 20240518 to the passed port, and the other two to the failed port.

Or am I just barking up the wrong tree here? 

Note that this is using imaginary data for now. But the production data will look similar.

For @DateTimeDiff() it should be FME date, yyyymmdd. This can be done using the DateTimeConverter.

In a Tester:

Attached a sample workspace.

scarter wrote:

nielsgerrits ​​​, I’ve tried End date > @DateTimeNow()​​

 

But that sends the four records to the Failed port. I was hoping it would send the two records where end date is 20240518 to the passed port, and the other two to the failed port.

 

Or am I just barking up the wrong tree here? 

 

Note that this is using imaginary data for now. But the production data will look similar.

The result of @DateTimeNow() is a bigger number as it also has hours, minutes, seconds, so if you want to test this it should be EndDate > @Left(@DateTimeNow(),8) to compare date to date.