Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Distinct months..?

Hi, I have dates in a table with the format yyyymmdd. I want to populate a list in a report with distinct months with the format mmm How can I do this?   Kent J.
  • Anonymous's avatar
    Anonymous
    4 years ago

    I created a copy of the column ProductionDate with the format 'mmmyyyy'. Then I grouped by the copy (MonthYear) and summarized 'ItemCount'. Success!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks!

This is what I got, my field ProductionDate is not recognized:

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    OK, I still have error on 'ProductionDate'

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I created a copy of the column ProductionDate with the format 'mmmyyyy'. Then I grouped by the copy (MonthYear) and summarized 'ItemCount'. Success!