Date(MonthStart(AddMonths(ExpenseStartDate,iterno()-1)),'YYYY-MM-DD')) as [Payment Date],
ExpenseFrequency,
Resident tblExpenseSchedule
while ExpenseEndDate > MonthStart(addmonths(ExpenseStartDate,iterno()-1));
Now I want to add to the if statement when the frequency = semi annual and when it is quarterly.
as you see above when frequency = yearly it shows the date and when monthly it increae the date by one month untill reaching the date end.
Anybody knows what should type in the if statement to make the payment date increases by 6 month when the frequency = Semi and increases by 3 months when it is qurterly.
