I'm using jQuery DataTable and the first column contain a custom date range. For ex: 22 Oct 2015 - 22 Nov 2015 where 22 Oct 2015 is the start date and 22 Nov 2015 is the end date. I want the sorting functionality to work on start date.
Let me explain a scenario: Let say I have 4 rows in DataTable and the first column date values are:
- 25 Aug 2016 - 21 Sep 2016
- 22 Oct 2015 - 22 Nov 2015
- 21 Oct 2015 - 21 Nov 2015
- 02 Dec 2015 - 02 Jan 2016
I want the sorting result in following format:
- 25 Aug 2016 - 21 Sep 2016
- 02 Dec 2015 - 02 Jan 2016
- 22 Oct 2015 - 22 Nov 2015
- 21 Oct 2015 - 21 Nov 2015
How to do this!