if today is the 3rd working day of the month

[#1]

Hi Experts

I hope you can help me , I am trying to create a QVD when today is the 3rd working day of the month

So the script below will create a QVD the 03rd of the month - but if the 3rd is not a working day it wont creat one

if num(Day(Today()),00)=03  then

MISDATA:

Load *
  
FROM

(biff, embedded labels, header is 3 lines, table is RCMT$)
Where  date([Date received by ddd])>=date('$(dDate)') and date([Date received by ddd])<=date('$(hDate)');

STORE MISDATA INTO $(vFileDate).qvd (qvd);
DROP TABLE MISDATA;

I think its a variation of

if  NetWorkDays(Date(MonthStart), Date(Today())) = 3 then

But I cant quite get it working

Any advise would really be appreciated

Thanks

A

[swuehl · Accepted solution]

Try

NetWorkDays(MonthStart(today()), today())

and maybe add your holidays as third ff. arguments.

[#3]

Thanks Swuehl