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 thi...
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.

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

     

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

    I got it now. It is working. Thanks