Question

While/looper


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

 


2 replies

Badge +2

@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