In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Date

nkr306_nkrs
7 - Meteor

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.

13 REPLIES 13
Luke_C
17 - Castor
17 - Castor

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.

 

Luke_C_0-1642541306749.png

 

nkr306_nkrs
7 - Meteor

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

nkr306_nkrs
7 - Meteor

Hi Luke C

 

I tried the updated format but its failing.

Luke_C
17 - Castor
17 - Castor

@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:

Luke_C_0-1642543316696.png

 

Labels
Top Solution Authors