ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find 15th workday of next month basis start date

Shaaz
9 - Comet

Hi,

 

I'm trying to find 15th workday of next month basis start date excluding weekend.

 

Below is the sample input along with expected output.

 

Shabaz_1-1653029664899.png

 

Can you please help me in achieving this.

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@Shaaz 
I thought it should be very simple

😂

0520-Shabaz.PNG

binu_acs
21 - Polaris

@Shaaz Similar to @Qiu solution

 

binuacs_0-1653032464421.png

 

Shaaz
9 - Comet

Hi,

 

Thank you, I'm able to achieve what is expected from the above 2 solutions.

 

But is there a much more optimized way to achieve this, since Generate Rows tool will increase the record count and degrade the performance of overall Alteryx run time since I'm working on millions of rows.

Shaaz
9 - Comet

--

binu_acs
21 - Polaris

@Shaaz you should get same number records in input and output . Can you check which date you are missing the output?

Labels
Top Solution Authors