How to add date function during export of excel sheet?

sfm143

I have used datatables to fetch records from database. Now as per requirement, I want to have records exported along with dates i.e., month wise (Tuesday, October 1, 2019).

     buttons: [
        'add',
      {
            extend: 'copyHtml5',
            exportOptions: {
                columns: [1,2,3,4,5]
            }
            },
            {
            extend: 'print',
            exportOptions: {
                columns: [1,2,3,4,5]
            },
            customize: function ( win ) {
                $(win.document.body)
                    .css( 'font-size', '10pt' )
                    .prepend(
                        '<img src="/images/abc.png" style="position:absolute; top:0; left:0;" />'
                    );

                $(win.document.body).find( 'table' )
                    .addClass( 'compact' )
                    .css( 'font-size', 'inherit' );
            }
            },{
            extend: 'excel',
            exportOptions: {
                columns: [1,2,3,4,5]
            },
            title:"Employee Leaves With abc"
            },{
            extend: 'csv',
            exportOptions: {
                columns: [1,2,3,4,5]
            },
            title:"Employee Leaves With abc"
            },{
            extend: 'pdf',
            exportOptions: {
                columns: [1,2,3,4,5]
            },
             title:"Employee Leaves With abc"
            }
       ],

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin