I have a task that needs to separate the contents of the data table based on the pair of dates.
Below is how my data table looks like. I need to separate each record based on their start date and end date.
For example, I have two entries for 9/21/2017 and 9/25 2017m I need to insert it to another datatable which will be created dynamically.
The next date is 9/22/207 and 9/27/2017, i need this to be also on another different data table to be added .
And the same for 9/24/2017 and 9/27/2017. I need to create the datatable on memory instead of creating a build datatable manually.
Hope someone can help me.