Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions?
Ask here!
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Hi All,
Need your help, from my raw data I need to insert a column with specific dates every month. It is divided into two cycles, every 1st - 15th of the month and 16th - 30 or 31st of the month (depending on how many days the month is).
Here is my raw data:
Here is what I want to achieve:
| EE | Type | No. | Start Date | End date |
| E1 | 2105 | 9 | 01/09/2020 | 15/09/2020 |
| E2 | 2105 | 9 | 01/09/2020 | 15/09/2020 |
| E3 | 2105 | 9 | 01/09/2020 | 15/09/2020 |
Is this possible?
Thanks!
Solved! Go to Solution.
Hi @Belletmns — You need to create two new columns through Formula tool:
Start Date:
"01/"+PadLeft(ToString([No.]), 2, "0")+"/"+DateTimeFormat(DateTimeToday(),"%Y")
End Date:
"15/"+PadLeft(ToString([No.]), 2, "0")+"/"+DateTimeFormat(DateTimeToday(),"%Y")
Try attached the workflow to know more about datatypes if you want date fields in String or Date.
If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution. Thank you.
