Solved

How to keep adding months to today's date?

  • 12 September 2019
  • 5 replies
  • 4 views
dataninja
Badge

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

Thanks in advance!

icon

Best answer by daveatsafe 12 September 2019, 18:55

View original

5 replies

daveatsafe
Rank
Userlevel 2
Badge +17

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:

dataninja
Badge

I figured it out.

 

 

First, I used a cloner:

 

And then used DateTimeCalculator for both Next_Month & Today_Date

 

Final Output:

dataninja
Badge

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

P
Badge +4

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

 

 

dataninja
Badge

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

28,670
Posts
109,366
Replies
36,531
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.