JQuery DataTable Time Sort

5/3/2017

ASKER CERTIFIED SOLUTION

zephyr_hex (Megan)

4/24/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

4/24/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

4/24/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

zephyr_hex (Megan)

4/24/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

4/24/2017

ASKER

I will look at these suggestions. FYI-these are race times so they are typically sorted fastest-to-slowest but sometimes by chip time, sometimes by gun time, and sometimes by start time.

SOLUTION

4/24/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

4/27/2017

ASKER

This is all very helpful. After reading it I think using the data type "date" on the columns as illustrated above is the best choice, followed by applying the ability to render 'out" the date part. If that is the case, how do I assimilate the "render" piece into this:

<script>
$(document).ready(function() {
    $('#results').DataTable( {
        "lengthMenu": [[10, 25, 50, -1], [10, 25, 50, "All"]],
        "columnDefs": [
               { "type": "date", "targets": [6,7,8] }
         ],       
         "ajax": {
                "url":"data_source_example.asp",
                "type":"POST"
        }
    } );
} );
</script>

Open in new window

SOLUTION

4/27/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

4/27/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

4/27/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

SOLUTION

zephyr_hex (Megan)

4/27/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

5/1/2017

ASKER

It looks like I have two different solutions being offered here? One by Huseyin KAHRAMAN and the other by zephyr_hex (Megan)

Right now I have tried the solution by Huseyin but it still doesn't sort correctly.

I tried zephyr's but couldn't figure out the render piece.

I appreciate your patience. Please look at the page and offer what you can. This is key to getting this ready and I am running a little short on time.

5/3/2017

ASKER

I'm throwing in the towel on this one. I do appreciate all of your help.