Month End Calculation
Month End Calculation
I have created my first function in Zoho Creator. Something I think I'll use often throughout the project.
date MonthEnd(date MyDate)
{
WorkingDate = input.MyDate.addMonth(1);
WorkingDate = WorkingDate.subDay(input.MyDate.getDay());
return WorkingDate;
}
This gives you the last day of the month for any date given.