How to Find Most Recent Date from DataTable Column

Question

I would like to highlight the rows which are having previous date by comparing with most recent date from the DataTable Column. Please advise. Thanks in advance!

Satish Bingi · Answer

Thanks for your quick support! Here, I tried with the below code which is working fine. Howevr, in the date place (' 9/8/2000 ') I want to call the max date variable, so that all the rows except max date will highlight. "targets": [0], "createdCell": function (td, cellData, rowData, row, col) { debugger; if (cellData var rowIndex = row + 1; $($('#tblData tbody tr:nth-child(' + rowIndex + ')')).addClass('highlight'); } }

Sam Hobbs · Answer

Your code has: maxCell.addClass('highlight'); maxCell is set to $(this) but I do not know what $(this) is. The name maxCell implies it is a cell. You say you want an entire row to be Red but you are only getting a single cell highlighted. I assume that highlighted means Red. The only place I see the color Red is for the highlight class. If you are setting only a cell to have that class then you are getting only a cell with that class.

Satish Bingi · Answer

I tried with the below.. however, it's highlighting only one cell instead of entire row and the other rows with older dates @foreach (var item in Model) { @Html.DisplayFor(model => item.birthDate) @Html.DisplayFor(modelItem => item.name) @Html.DisplayFor(modelItem => item.group) $(function (td, cellData, rowData, row, col) { var maxCell = undefined; var maxVal = undefined; $('.dateRow').each(function () { var that = $(this); var dt = new Date(that.text()); if (!maxCell || dt maxCell = that; maxVal = dt; } }); maxCell.addClass('highlight'); }); .highlight { background-color: red; }

Amit Mohanty · Answer

Still not clear. What is the logic behing it and explain what you have done till now?

Satish Bingi · Answer

Here is the output I am looking for. Date Of Birth Name Group 21/01/1982 Vinod Operations 23/05/1980 Harshavardhan Operations 18/11/1979 Bhushan Implementation

Amit Mohanty · Answer

Could you clarify your question more concisely with some example and please explain what you have accomplished so far?

How to Find Most Recent Date from DataTable Column

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (6)