Ever had to calculate the number of days starting from a number of workdays and even deal with holidays.
A pretty straightforward example using the DateTimeUtil class and DayOfWk method.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
static void WorkDaysToDays(Args _args) { int workDays = 10; int days = 0; date startDate = systemDateGet(); CalendarId calendarId = CompanyInfo::find().ShippingCalendarId; ; if(calendarId) { while(workDays > 0) { if(dayofwk(startDate) != 6 && dayofwk(startdate) != 7 && WorkCalendarDate::isDateOpen(calendarId,startDate)) { workDays--; days++; } else { days++; } startDate = DateTimeUtil::date(DateTimeUtil::addDays(DateTimeUtil::newDateTime(startDate,0),1)); } info(strfmt("Workdays = %1, Days = %2",workDays,days)); } else { error("No calendarId found"); } } |