date back minus weekends and holidays

[#1]

Hi All,

I need to calculate date back:

today() - 15 networkdays

So it needs to be date that is 15 days back from today but excluding any weekends or holidays.

Can you please help with the calculation?

Thanks

[#2 · Accepted solution]

// create dates from period range

let vWeekendsHolidays = 15 - NetWorkDays(today()-15,today());

let vStart = num(today()- 16 - $(vWeekendsHolidays));

let vEnd = num(Today());

DateID:

LOAD

    date(RowNo() + $(vStart) - 1) as DateID,

    1 as Flag

AutoGenerate ($(vEnd) - $(vStart) + 1);

[#3]

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

LET vDate=Today();

for flag=1 to 15

  LET vDayName=WeekDay('$(vDate)');

  IF Num('$(flag)')=15 then

  EXIT For;

  ENDIF

  IF vDayName='Sat' or vDayName='Sun' then

  vDate=Num('$(vDate)')-1;

  flag=Num('$(flag)')-1;

  ELSE

  vDate=Num('$(vDate)')-1;

  ENDIF

NEXT flag;

Hope it helps