Creating Month & Year Column

[chughes49]

I am trying to create 3 separate columns that pull from this date '2019-01-31' to create

1) "Jan" 

2) "2019'

3) "Jan 2019" 

Any help would be super appreciated.

[Thableaus · Accepted solution]

Hi @chughes49 

I really recommend you to check the DateTimeFormat function.

You can see how to use the function and all parameters here. That's the best way to learn.

https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm

Cheers,