Skip to main content
  • EN

Hi, how do I keep adding records (In red) until I hit 2025 - 12 - 12?

Thanks in advance!

Hi @trungn1993,

You can use a DateTimeCalculator transformer to calculate the number of days between today and 2025-12-12, then another one to calculate the date for each of those days:

I figured it out.

 

 

First, I used a cloner:

 

And then used DateTimeCalculator for both Next_Month & Today_Date

 

Final Output:

Hi @trungn1993,

You can use a DateTimeCalculator transformer to calculate the number of days between today and 2025-12-12, then another one to calculate the date for each of those days:

I just posted my solution too 🙂 Thanks @daveatsafe anyways

I'm not gonna ask why, and rather just give one solution. But I do advice to calculate these values on the fly, and not create a lot of dead lookup data. Its a big performance killer.

 

 

Here is a Python Creator example:pyc.txt

 

 

I'm not gonna ask why, and rather just give one solution. But I do advice to calculate these values on the fly, and not create a lot of dead lookup data. Its a big performance killer.

 

 

Here is a Python Creator example:pyc.txt

 

 

Thanks, nothing beats Python when it comes to performance!

Reply


Community Stats

31,821
Posts
120,861
Replies
39,452
Members

Latest FME

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.