CALCDATE, dateformula and int

Business Central/NAV Developers Forum
1

Hi! I am trying to calculate a date by using PeriodeLength, which is a dateformula type, and number of periods which is an int. Further I am going to use the CAlCDATE and a referance date to find the exact posting date. Do you know a way to multiply the number of periods by the dateformula type? example: PeriodLength is 3M. Number of periods is 2. How can I do 2*‘3M’ and use the result in CALCDATE(ANSWER,REFDATE)? Can anyone help me pleeease?

2

Try this: FOR I:= 1 to NumberOfPeriods DO RefDate := CALCDATE(PeriodLength,RefDate);

3

Thank you! This works just fine! You saved my dag!