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
![28vf7zs.jpg](/board/proxy.php?image=http%3A%2F%2Fi66.tinypic.com%2F28vf7zs.jpg&hash=295f3217bf1498d2e01048add74892dd)
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:
![2r4szus.png](/board/proxy.php?image=http%3A%2F%2Fi66.tinypic.com%2F2r4szus.png&hash=d4a0d2572866846df4a010702b30221f)
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!!!