How do you make an Editor column sort by date asc and keep empties below entries with dates?

How do you make an Editor column sort by date asc and keep empties below entries with dates?

koniahinkoniahin Posts: 188Questions: 40Answers: 7

The subject says it all. The date column has entries with dates yet to be assigned. If you click the header and sort by asc the empties display above those with dates which is natural sorting. However we wish to see those with dates above tehe empties like:

2025-07-01
2025-07-02
2025-07-02
2025-07-04
2025-07-05
2025-07-10
*** (no date assigned yet)





tried many options with columDefs such as:

  { 
    targets: 7, // replace with your actual column index
    type: 'datetime',
    render: function (data, type, row) { 
      return data || ''; // ensures null shows empty
    }
  },

Tx

Answers

Sign In or Register to comment.