Getting minimum - Min() - for DateTime column in a DataTable using LINQ to DataSets?
Posted
by Jay Stevens
on Stack Overflow
See other posts from Stack Overflow
or by Jay Stevens
Published on 2010-04-24T12:42:46Z
Indexed on
2010/04/24
13:13 UTC
Read the original article
Hit count: 386
I need to get the minimum DateTime value of a column in a DataTable. The DataTable is generated dynamically from a CSV file, therefore I don't know the name of that column until runtime. Here is code I've got that doesn't work...
private DateTime GetStartDateFromCSV(string inputFile, string date_attr)
{
EnumerableRowCollection<DataRow> table = CsvStreamReader.GetDataTableFromCSV(inputFile, "input", true).AsEnumerable();
DateTime dt = table.Select(record => record.Field<DateTime>(date_attr)).Min();
return dt;
}
The variable table is broken out just for clarity. I basically need to find the minimum value as a DateTime
for one of the columns (to be chosen at runtime and represented by date_attr
).
I have tried several solutions from SO (most deal with known columns and/or non-DateTime fields). What I've got throws an error at runtime telling me that it can't do the DateTime conversion (that seems to be a problem with Linq?)
I've confirmed that the data for the column name that is in the string date_attr
is a date value.
© Stack Overflow or respective owner