Forum Discussion

unknown_anony's avatar
unknown_anony
Icon for Helper II rankHelper II
2 years ago
Solved

Error While sorting a date column with Yearmonth

Hello I am unable to sort the date column with the Yearmonth Custom column. getting this below error.  Please Suggest  Thank you  
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hi! In order to sort Approved Date, you will need a column that has the same value for monthyear. In your data YearMonthNo has different values for each row. So, for Jan 22 of approved date you would need a column that signifies that this is 1 (for example, you could make a column that has 1/1/2022 for everything that is Jan 22, 2/1/2022 for everything that is Feb 22, etc.).