Hi All,
I am new to Alteryx, heavy user of Power Query but now I am navigating my way to learn Alteryx.
Just need your help on converting Date Column: 2022-10-28 to the following format/Output
Month Name: Oct
Start of the Month: 2022-10-01
Start of the Week: 2022-10-23
End of the Week: 2022-10-29
Week of the Year: WK 44
Weekday: Friday
Year: 2022
I have been searching for the answer here community but maybe i am not using the right keywords to find the solutions available.
Thanks.
Elmer
Solved! Go to Solution.
@elmerbuscado attached is a workflow with examples for the date calculations you listed above. I also recommend checking out the help documentation on DateTime Functions, which includes a reference for specifiers in the DateTimeFormat() function.
@elmerbuscado
I think we are looking at the Date Time Function
For specifiers, we can refer below
https://help.alteryx.com/20221/designer/datetime-functions