5 Replies Latest reply: Aug 29, 2018 8:38 AM by Sreeni Tulabandula RSS

    Date Sorting

    avneet taneja

      I have a date column and I have converted into month-year by doing

      =Month(date) & '-' & (Year(date) )

       

      now I have two questions:

       

      1. I am getting a date as - as one of value

      2. how to sort date in month-year.

      I tried doing that by going to  sorting --> expression -->Month(date) & '-' & (Year(date) ) but it didn't sort it out