Find Business day from date field

[AnandKumar1]

Hi,

I've a date field which has list of all business day for a given month. But the problem is some are in proper format like 1,2,3etc..but some are are like Monday1,Tuesday2. This means 1st monday of month ,2nd tuesday of month.

Is there any way to extract business day from these kinds of format also?

I've attached my workflow to calculate business day.

Date	Bus. Day
202006	1
202006	2
202006	Monday2
202006	4
202006	Tuesday1
202006	Friday3

[ImadZidan]

@AnandKumar1 ,

If my finding are correct, add a unique tool at the end like  below and check all fields.

[AnandKumar1]

@ImadZidan 

I cannot use Unique here as there is no unique field. Same Business day may come for multiple reports.

Its really messed up here. I've attached comment section in workflow. pleas check 

[ImadZidan]

@AnandKumar1 ,

No problems, lets us have a look at the whole workflow . I am sure we will figure it our.

[ImadZidan · Accepted solution]

Hello @AnandKumar1 ,

I think the final join by record position was causing the issue I think. When putting records together, it was nothing there to map the order of such join. I generated a record ID from till the end to use in the join to ensure the records from the due and sent are mapped correctly.

I kept the recordID at the end for you to see how they match.

Have a look and hopefully it looks better now.

[AnandKumar1]

@ImadZidan 

How do i say 'thank you' to you. You saved my weekend.

One small thing and i was struggling like anything. It worked perfectly

Thanks a Lot.