Data Table date column

[whitestar (Phyo)]

have you tried the following methods?

Determine most recent and oldest dates

Hi @robot123, Max Date DateTime maxDate = Convert.ToDateTime( ((from DataRow dr in dt.Rows orderby Convert.ToDateTime(dr["DateColumn"]) descending select dr).FirstOrDefault()["DateColumn"] ) ) Min Date DateTime minDate = Convert.ToDateTime( ((from DataRow dr in dt.Rows orderby Convert.ToDateTime(dr["DateColu…

Find the maximum and minimum dates in a datatable

Hi All I need to find the maximum and minimum dates in a datatable. Can anyone please help me in this @aksh1yadav , @vvaidya

Select(find) max date from datatable

Hi there @Alexey, You can use the following expression: [YourDTVariable].AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item([YourColumnIndex/Name]).ToString)).ToString This will return a String value. On a side note, you will receive an error in the event any of these values cannot be parsed as a DateTime. Thanks, Josh