Date

[nkr306_nkrs]

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.

[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.

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