Date Format for Mth and Yr

[KnowNow]

Hello,

I have a date column that I formated to (mmmm yyyy). This format shows the full month as "January". Whenever I try to abbr. the mth by changing the format to (mmm yyyy), the columns shows this "10ar 2001 (Jan 2023)". How can I format the column to only show the date in parenthesis only?

Thanks,

[HotChilli · Accepted solution]

Can you post a picture of the following :

Model View->Select the field  then look in Properties ->  the formatting section lower down

--

It looks like you have the correct format but there's extra stuff in there too.

[KnowNow]

I was typing the format code in the column instead of the properties pane. When I typed it in the properties pane, it worked. Thanks

[KnowNow]

I got it now. It is working. Thanks

[KnowNow]

Yes, here is the picture. I tried to abbre. March to Mar and I also remove the March 2001. When I select the dropdown that is the only format that shows month and year only. I do not see one available with the abbrev. month. Thanks