Forum Discussion

KnowNow's avatar
KnowNow
Icon for Helper I rankHelper I
2 years ago
Solved

Date Format for Mth and Yr

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,

Need Help
  • HotChilli's avatar
    HotChilli
    2 years ago

    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.

4 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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's avatar
      KnowNow
      Icon for Helper I rankHelper I
      2 years ago

      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's avatar
      KnowNow
      Icon for Helper I rankHelper I
      2 years ago

      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