Forum Discussion
Solved
Sort MonthName + Year for Multiple year
Hi , I have a requirement where I need show data like Month_name + Years in Assending/Desending , Lets say i have a Year and Month_name for 2017 to 2019. Each year having Jan to Dec, I would ...
If you want dynamic, you can format your date in new column (as I suggested previous) or new table (as lc_finance suggested). Sorting by custom format date "yyyy.MM.00" sort first in year, next month. All is dynamic and new dates goes to the right place between values.
Regards
In this senario we are giving static date values.Tomorrow if date added in DB level we will get issue here. Please let me know any other option in this case.
If you want dynamic, you can format your date in new column (as I suggested previous) or new table (as lc_finance suggested). Sorting by custom format date "yyyy.MM.00" sort first in year, next month. All is dynamic and new dates goes to the right place between values.
Regards