Forum Discussion
Helper IIError While sorting a date column with Yearmonth
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.).
Super UserHi! 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.).