In a need to create Payment schedule

[alec1982]

Hi guys,

I am having hard time creating a payment scehdule table based on the following example:

ID          StartDate          EndDate          Amount

1          2010/09/15         2013/10/8           500

2          2009/03/01         2015/03/31         300

3          2011/04/01         2011/04/01          200

I need to create a Payment date which should start on the first day of every month as the following example:

ID     StartDate          EndDate          PayementDate

1

2010//09/15

2013/10/08

2010/09/01

1

2010//09/15

2013/10/08

2010/10/01

1

2010//09/15

2013/10/08

2010/11/01

And so on to the last month.

Anybody can help Please.

Thxs,

[avastani]

Test the variables to ensure there is a value in them

Thanks.

[alec1982 · Accepted solution]

I guess that i have fixed it a little differently:

Table1:

Load ID,

     StartDate,

     EndDate,

AddMonths(StartDate,iterno()-1) as [Payment Date]

From Source file;

Payment Schedule:

Load ID,

StartDate,

EndDate,

MonthStart([Payment Date]) as PaymentDate

Resident table1

Thank you so much for your help.