Days From Closest Day of Week Occurrence [DaysFromDayOfWeek]

Return to Complete List of Functions

The Days From Closest Day of Week Occurrence function determines the number of days between the current record and the closest occurrence of a day of the week. Parameters ------------------ Day of Week The day of the week to resolve where:                       1=Sunday, 2=Monday, 3=Tuesday, 4=Wednesday, 5=Thursday, 6=Friday, 7=Saturday. Occurrence    The occurrence number of the day of the week to resolve, where:                       1=First Occurrence, 2=Second, 3=Third, 4=Fourth, 5=Last Occurrence (Fourth or Fifth) Function Value ------------------------ This function determines the number of days between the current record and the closest occurrence of a day of the week. The value is zero if the current day is the next occurrence. Values in the past are returned as negative values. Example ------------------ DaysFromDayOfWeek(2,3)  = Days away from closest third Monday Current Day             Value ----------------------------------------- Second Thursday        4 Second Friday             3 Third Monday              0 Third Tuesday             -1 Third Wednesday       -2