Sorry, there is no such macro-parameter. You will need to implement it yourself using "backward" loop from the last calendar day of week. Here is the sample script using the following logic: // get today's date Today( dt ) // get current day number DayNumber( dt, day ) // find end of this week Subtract 7, day, day DateAdd( dt, day, dt ) // subtract 1 day for American calendar, subtract 2 days for Europian calendar // this depends on what is counted as the last day of week (Sunday, Saturday) DateAdd( dt, -2, dt ) // Check holidays isHoliday( dt, hd ) LoopWhile( hd, END_LOOP ) DateAdd( dt, -1, dt ) isHoliday( dt, hd ) END_LOOP: // all done, dt now = last bus. day of week : Is there a macro-parameter that will determine the last business day of the : week? I did not see any in the Help, but thought it might exist.
|