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["DateColumn"]) ascending select dr).FirstOrDefault()["DateColumn"] ) )

Regards,
Arivu

1 Like