Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Test the variables to ensure there is a value in them
Thanks.
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.