Skip to main content
  • EN

Hi

I have a SQL table where I have

cust no. = 1, Created date = 2020-02-01 and Last date = 2020-06-30.

cust no. = 2, Created date = 2020-01-01 and Last date = 2020-07-30.

I need to insert each month between Created date and Last date into a SQL table for each cust no.

 

Any ideas how do I do that?

I tried Looper and Endless looper but I can't make it work and can't find any documentation

 

@lenanielsenmail​ You might be able to use the DateTimeCalculator Mode: Calculate Interval Between Datetimes and return the result in months. Use the Cloner to make number copied of your feature for each month and maybe another DateTimeCalculator to get the date for each month. That should avoid any looping.

Thanks. I'll try that

Reply


Community Stats

30,177
Posts
114,556
Replies
37,843
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.