title: Jquery datatables export column as type "Date"
body: <p>Hi I have a table where I have some columns that need to be exported as currency and some to exported as date</p>
  
  <p>But datatables export date as string. I know the reason to export in the format as specified by the user. But my client needs to do some calculations for which he wants the column to be exported as date and not as string. Does anyone have any ideas how to do it?</p>
  
  <p>Note* I have tried orthogonal option=> Its not working</p>
  
  <p>Below is the code that refers to the problem:</p>
  
  <pre><code>var buttonCommon = {
          exportOptions: {
              format: {
                  body: function ( data, column, row ) {
                      // Strip $ from salary column to make it numeric
                      return column === 5 ?
                          data.replace( /[$,]/g, '' ) :
                          data;
                  }
              }
          }
      };
  </code></pre>
  
  <p>Here the user is converting string column to number. Is there anything with which I can convert string to date?</p>
  
  <p>I have tried this code </p>
  
  <pre><code>exportOptions: {
                      format: {
                          body: function ( data, column, row ) {
  
                          // Strip $ from salary column to make it numeric
                          var customDate = new Date('2016/10/10');
                          customDate = (customDate.getMonth() + 1) + '/' + customDate.getDate() + '/' +  customDate.getFullYear();
  
                          return column === 12 ? customDate: data;
                          }
                      },
                      columns: ':visible',
                  },
  </code></pre>
  
  <p>But it still returns
  10/10/2016
  10/10/2016
  10/10/2016
  10/10/2016</p>
  
  <p>*as string</p>