Col Formula Month()

[#1]

I have a data table where I have multiple date with times. I'm trying to change all the dates into just the month and maybe even a month-year format.

I know I've done this before by selecting the column going to formula and putting together Month(DateandTime) than I would use recode to change numbers into Jan. - Dec.

When I'm trying today, the Month() formula is changing my date to just dots. I've looked at other posts and the formula is what I'm suppose to be using. I'm not sure why I'm not getting my expected result?

[#2]

If(:month <= 2 | :month >=12, 
     season="Winter",
     :month <=5, season="Spring",
     :month <=8, season="Summer",
     season="Fall"
); 

[#3]

Hello All, 

I am able to use a lot of help provided on this forum. I am looking for some help with attached table. Column 2 has months from year 2019 and 2020. I need to add year next to month.

[#4]

Here is a formula that will work

Substr( Format( :Date, "Monddyyyy" ), 1, 3 ) || " " || Char( Year( :Date ) )

[#5]

Million thanks :)