Date

Hi Friends

I am running alteryx workflows based on the dates. I have a scenario, where I want 1st working day of next month. For example, if the current date is 01/04/2022 then I need 1st working day of next month as 02/01/2022. Date format is mm/dd/yyyy. Please help me to solve this issue.

Workflow

Accepted answers

All comments

atcodedog05

Hi @nkr306_nkrs

Here is how you can do it. Doesn't account holidays only weekends

IF DateTimeFormat(DateTimeAdd(DateTimeFirstOfMonth(),1,"month"),"%a")="Sun" 
THEN 
DateTimeAdd(DateTimeAdd(DateTimeFirstOfMonth(),1,"month"),1,"day")
ELSEIF DateTimeFormat(DateTimeAdd(DateTimeFirstOfMonth(),1,"month"),"%a")="Sat" 
THEN 
DateTimeAdd(DateTimeAdd(DateTimeFirstOfMonth(),1,"month"),2,"day") 
ELSE DateTimeAdd(DateTimeFirstOfMonth(),1,"month") ENDIF

Workflow:

Hope this helps : )

1st next month working day.yxmd

bensilv

Hi @nkr306_nkrs,

Depending on whether you want to take holidays in to account, you should find your solution in one of these two posts:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Count-working-days/td-p/672159
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Business-Day-formula/td-p/484513

Essentially you will want to utilise the DateTime Functions (https://help.alteryx.com/20213/designer/datetime-functions) and add a lookup table in to the mix to account for holidays!

Ben

philipmannering

Does this do what you need? Doesn't take into account holidays.

next working date.yxmd

messi007

@nkr306_nkrs,

Please see below :

1- Convert and get the first date of month

2 - Display only needed columns :

Attached the workflow,

Regards,

ConvertDate.yxmd

nkr306_nkrs

I am getting the result but in "2022-02-01 00:00:00 " format. Can you help me with the solution which give me mm/dd/yyyy (in this case 02/01/2022) format with out the time. Thanks in advance

Luke_C

Hi @nkr306_nkrs

This is because the formula is using 'datetimefirstofmonth' which looks at the first day of the current date. I modified @atcodedog05 's workflow slightly to take a date coming in, and use it to figure out the first day of the next month, leveraging datetimetrim functions instead.

1st next month working day (1).yxmd

nkr306_nkrs

It seems to be working but when I try with some random future date. It is failing. Can you please help.

nkr306_nkrs

Hi Luke C

I tried the updated format but its failing.

Luke_C

@nkr306_nkrs You'll need to be a bit more specific. What do you mean by failing? Send a screenshot. Are you passing a date into the formula (meaning alteryx date yyyy-mm-dd)? If not convert it first.

I tried a future date and it seems to work:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703