Hello,
I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.
e.q. consider i have a table with
Subscriber
Effective_date
Expiriation_date
Service_Code
Now i want to dynamically create a custom table which will have duplicate entries with the same
Subscriber
Effective_date
Expiriation_date
Service_Code
BUT I NEED ALSO
a new columns of the dates between date being "Effective_date" & "Expiriation_date" so I could filter and see how much month he was subscriber until he left
right know I did this:
but instead of 3 - which is the number of month until the customer left, I want to see the months between..
May
June
July
how can I do this??
thanks a lot!!!
I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table.
e.q. consider i have a table with
Subscriber
Effective_date
Expiriation_date
Service_Code

Now i want to dynamically create a custom table which will have duplicate entries with the same
Subscriber
Effective_date
Expiriation_date
Service_Code
BUT I NEED ALSO
a new columns of the dates between date being "Effective_date" & "Expiriation_date" so I could filter and see how much month he was subscriber until he left
right know I did this:

but instead of 3 - which is the number of month until the customer left, I want to see the months between..
May
June
July
how can I do this??
thanks a lot!!!