Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sorting based on MOnth and Year

Hi PLease help on this

 

facing issue with sorting based on Month and Year

 

Date is SimpleDate

Presently records are displaying like

Apr-22,Apr-23,May-22,May-23. I need to sort in based on month  and year please help on this

Need Help
Show and Tell
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column "Month-year" sort by "Date" column.

    Another approach:

    Index = YEAR([Date])*100+MONTH([Date])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • v-zhangti's avatar
    v-zhangti
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column "Month-year" sort by "Date" column.

    Another approach:

    Index = YEAR([Date])*100+MONTH([Date])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      thanks you it worked for me