I have cases with various starting dates and thus also various payment and closing dates. I have managed to concatenate the different tables into one and the 3 dates into one, but I now need the following in the load script:
All starting dates should be month 0 (no problem)
Payment dates should then be month 1, 2, 3, 4 etc no matter if the payment month is April, May, June, July etc
Closing date should be after the same principle as Payment dates, i.e. starting date minus closing date
E.g.
Starting date March 2011=0, Payment date, March 2011=1, April 2011=2, May 2011=3, June 2011=4. Closing date: July 2011=5
Starting date April 2011=0, Payment date: April 2011=1, May, 2011=2, June 2011=3, Closing date: June 2011=3
How can I do this ?
