Latest Contributions by ChrisFox

Hi Kyle, Give the update expression below a shot. In this I updated the holidays variable to be a dictionary, where the key is the what should be down for the holiday and the value is the list of holidays that apply to that option. So you can see, in the code below for the holidays you specified the next pickup will either be the next Thursday, or occur at the Next Schedule Pickup. The only thing this script doesn't account for now is Christmas and New Years are 1 week apart. What is the expectation for these holidays when the pickup date falls on Christmas the Next Scheduled Pickup would be New Years Day. Would you want the next pickup to be a week after New Years then? /*If pickup occurs weekly, specify 1. If every other week specify 2, etc.*/ var pickupWeekInterval = 1; /*Specify a date in the past in which pickup occurred. This is used in the case where pickup doesn't occur every week to determine the weeks where pickup is occurring.*/ var firstPickupWeek = Date('2017-01-01'); /*If the pickup service isn't available year-round specify the first and last day of the season that pickup will occur, [[Start Month, Start Day], [[End Month, End Day]]*/ var openSeason = [[1,1],[12,31]] /*Specify if the next scheduled pickup day falls on a holiday, when will the next actual pickup be. "Next Weekday" - The pickup will occur on the next weekday after the holiday "Next Day" - The pickup will occur on the next day after the holiday "Next Day of Week - 4" - The pickup will occur on the next day of the week (Sunday = 0, Saturday = 6) "Next Scheduled Pickup" - The pickup will occur on the next scheduled day after the holiday*/ /*Specify any holidays where pickup will not occur, [Month, Day] Specify any variable holidays where pickup will not occur, [Occurrence, Month, Day of the Week (Sunday = 0, Saturday = 6)] These are holidays that don't fall on the same date every year, i.e. Memorial Day, Labor Day, Thanksgiving [-1,5,1] corresponds to Memorial Day -> Last occurrence in May of a Monday [1,9,1] corresponds to Labor Day -> 1st occurrence in September of a Monday [4,11,4] corresponds to Thanksgiving -> 4th occurrence in November of a Thursday*/ var holidays = { "Next Weekday": [], "Next Day": [], "Next Day of Week - 4": [[-1,5,1],[7,4],[1,9,1]], "Next Scheduled Pickup": [[1,1],[4,11,4],[12,25]] } var pickupDays = []; var pickupDaysFields = [$feature.SUNDAY, $feature.MONDAY, $feature.TUESDAY, $feature.WEDNESDAY, $feature.THURSDAY, $feature.FRIDAY, $feature.SATURDAY] for (var k in pickupDaysFields) { if (pickupDaysFields[k] == 'Yes') { pickupDays[Count(pickupDays)] = k; } } if (Count(pickupDays) == 0) return; function calcRelativeHoliday(week, month, day, year) { var holiday; if (week < 0){ var lastDay = DateAdd(Date(year, month + 1, 1), -1, 'days'); var dayOfWeek = Weekday(lastDay); var dayDiff = day - dayOfWeek; if (dayDiff > 0) dayDiff -= 7; holiday = DateAdd(lastDay, dayDiff + ((week + 1) * 7), 'days'); } else{ var firstDay = Date(year, month, 1); var dayOfWeek = Weekday(firstDay); var dayDiff = day - dayOfWeek; if (dayDiff < 0) dayDiff += 7; holiday = DateAdd(firstDay, dayDiff + ((week - 1) * 7), 'days'); } return holiday; } function getNextPickupDay(fromDate) { var currentDay = Weekday(fromDate); var pickupOffset = 0; if (pickupWeekInterval > 1){ var weekDif = DateDiff(DateAdd(fromDate, 0 - currentDay, 'days'), DateAdd(firstPickupWeek, 0 - Weekday(firstPickupWeek), 'days'), 'days') / 7; weekDif = weekDif % pickupWeekInterval; if (weekDif > 0) pickupOffset = pickupWeekInterval - weekDif; } var difDays; var nextPickupDay; if (pickupOffset > 0) { nextPickupDay = pickupDays[0]; difDays = nextPickupDay - currentDay; difDays += (7 * pickupOffset); } else { for(var k in pickupDays) { if (pickupDays[k] >= currentDay) { nextPickupDay = pickupDays[k]; break; } } if (IsEmpty(nextPickupDay)) nextPickupDay = pickupDays[0]; difDays = nextPickupDay - currentDay; if (nextPickupDay < currentDay) difDays += (7 * pickupWeekInterval); } return DateAdd(fromDate, difDays, 'days'); } function getHolidays(fromDate) { var holidayDates = {}; for (var k in holidays) { var dates = []; for (var d in holidays[k]) { if (Count(holidays[k][d]) == 2) { var holiday = Date(Year(fromDate), holidays[k][d][0] -1, holidays[k][d][1]); if (holiday < fromDate) { holiday = Date(Year(fromDate) + 1, holidays[k][d][0] -1, holidays[k][d][1]); } dates[d] = holiday; } else { var x = holidays[k][d]; var holiday = calcRelativeHoliday(x[0], x[1]-1, x[2], Year(fromDate)); if (holiday < fromDate) { holiday = calcRelativeHoliday(x[0], x[1]-1, x[2], Year(fromDate) + 1); } dates[d] = holiday; } } holidayDates[k] = dates; } return holidayDates; } function validateSeasonPickup(pickupDate) { var startSeasonMonth = openSeason[0][0]-1; var startSeasonDay = openSeason[0][1]; var endSeasonMonth = openSeason[1][0]-1; var endSeasonDay = openSeason[1][1]; if (Date(Year(pickupDate), startSeasonMonth, startSeasonDay) > Date(Year(pickupDate), endSeasonMonth, endSeasonDay)) { if (pickupDate < Date(Year(pickupDate), startSeasonMonth, startSeasonDay) && pickupDate > Date(Year(pickupDate) - 1, endSeasonMonth, endSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate), startSeasonMonth, startSeasonDay)) } else { if (pickupDate < Date(Year(pickupDate), startSeasonMonth, startSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate), startSeasonMonth, startSeasonDay)); else if (pickupDate > Date(Year(pickupDate), endSeasonMonth, endSeasonDay)) pickupDate = getNextPickupDay(Date(Year(pickupDate) + 1, startSeasonMonth, startSeasonDay)); } return pickupDate; } function validateHolidayPickup(pickupDate, holidayDates) { for(var k in holidayDates) { for (var d in holidayDates[k]) { if (pickupDate == holidayDates[k][d]) { if (k == "Next Scheduled Pickup") { pickupDate = getNextPickupDay(DateAdd(pickupDate, 1, 'days')); } else if (k == "Next Day") { pickupDate = DateAdd(pickupDate, 1, 'days'); } else if (k == "Next Weekday") { var currentDay = Weekday(pickupDate); if (currentDay > 4) { pickupDate = DateAdd(pickupDate, 8 - currentDay, 'days'); } else { pickupDate = DateAdd(pickupDate, 1, 'days'); } } else if (Find('Next Day of Week', k) > -1) { var dayOfWeek = Number(Right(k, 1)); var currentDay = Weekday(pickupDate); if (currentDay > dayOfWeek) { pickupDate = DateAdd(pickupDate, (dayOfWeek + 7) - currentDay, 'days'); } else { pickupDate = DateAdd(pickupDate, dayOfWeek-currentDay, 'days'); } } break; } } } return pickupDate } var nextPickup = getNextPickupDay(Today()); nextPickup = validateSeasonPickup(nextPickup); nextPickup = validateHolidayPickup(nextPickup, getHolidays(nextPickup)); return Text(nextPickup, 'dddd, MMMM D');   ... View more

Hi @S6 , I am working with 2.7 and was able to access the Update Domain Tool. I am curious if you cloned your python environment. I have experienced problems in the past with upgrading Pro and a cloned python environment breaking after the upgrade. When I delete the cloned environments it typically fixes this issue. ... View more