Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to Create a Month Year Column in Calendar

Hello all,    I am trying to find a formular to create a mont year column (eg: November 2019, December 2019) that can also be sorted chronoically (eg: November 2019, December 2019, Janauary 2020, F...
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous ,

    Why are giving column = Month Year = format([Date],"mmmm yyyy")

    you have to give only

    Month Year = format([Date],"mmmm yyyy")

    or

    Month Year = format([Date];"mmmm yyyy")

    Create a month year sort column

    Month year Sort = format([Date],"YYYYMM")