How Convert Date to Month Name, to Week of Year, Weekday, Week of the Month, etc.?

Question

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

MatthewO · Accepted Answer

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

Qiu · Accepted Answer

@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