Need to calculate 6th working days in script

[ashis]

Hi ,

I have a table in database that gives me all working days in DD/MM/YYYY format column name workingdays

Based on this column I need to calculate 6th working day for a month in the script level. If it is 6th working day then run the script if not then exit .

in the screenshot attached,

01/04/2021 - 1st working day in April

06/04/2021 - 2nd working day in April

07/04/2021 - 3rd working day in April

likewise I need to calculate 6th working day

if (condition =6th working days, then run my script , else exit)

Please could you help.

[QFabian]

Hi @ashis , you can try something like this :

A:
Load distinct
workingdays
from yoursoource
where day(workingdays) = 6;

if NoOfRows('A')>0 then
Load
fields,
workingdays
from yoursoource;
end if

[ashis]

Hi QFabian,

Thank you very much for your reply. I applied your logic however it is giving me 6th day of each month.

If you see my post above I want to calculate first , second … working days based on the dates available in my table. Your logic is giving me this output. Please find the attached screen shot.

Regards,