Month name from date column

[Keyur Parekh 2]

Hi All,

Quick question - I want to create a calculated column to reflect month name as a string like "Jan", "Feb"... based on date coulumn, what is the formula for this I tried Month([Date Column]) and formatted it as string and I get the desired result however the data type of this column reflects integer even if it is formatted as string - this is creating issues with column matches from another data table due to integer/string conflict.

Does anyone knows any other formula that simply convert date to month name "Jan", "Feb" as a string

Thank you so much.

Best,

Keyur Parekh

[Manoj Singh]

Hello Keyur,

Try the below things at your end to achieve your goal:

Case when Month([date column])=1 then "Jan"

when Month([date column])=2 then "Feb"

when Month([date column])=3 then "Mar"

when Month([date column])=4 then "Apr"

when Month([date column])=5 then "May"

when Month([date column])=6 then "Jun"

when Month([date column])=7 then "Jul"

when Month([date column])=8 then "Aug"

when Month([date column])=9 then "Sep"

when Month([date column])=10 then "Oct"

when Month([date column])=11 then "Nov"

when Month([date column])=12 then "Dec"

end

Hope it helps.

Regards

Manoj Singh

[Keyur Parekh 2]

Thank you so much Manoj. Appreciate your help!!

[Anders Gavare]

Turning it into a string via concatenation with an empty string could work:

 

"" & Month([Date])

[Jason Dai 3]

Thanks!  It works for me!

[Manoj Singh]

You are always welcome :)

[Karam Rai]

Hi Manoj,

When I try this formula, the months get scrambled into a different order. When I go to the sort order to try and move them back into chronological order, it does not allow me to. Any insight as to why this may be happening

Thanks,

Karam

[Gonzalo Piotti]

Hi, it's better to cast to a Date and then apply formatting for example

Date([Column])and then in apperance: MMM/yy gives you "Jan-19"

[Tiffany Lai]

Try DatePart('month', [YourDateColumn])