Calculating min of Dates

[Vamshi_Krishna_Aluvala]

I have Date Column in DT
Convert.ToDateTime(DT.Compute(“MIN(Date)”,“”))
This isn’t working if date format is in dd.MM.yyyy
Is thier any alternative solution?

[shreyash_shirbhate]

@Vamshi_Krishna_Aluvala

Convert.ToDateTime(DT.Compute(“MIN(Date)”,“”))

Hi @Vamshi_Krishna_Aluvala

Try below expression

Convert.ToDateTime(DT.Compute(“MIN(Date)”,“”).ToString)

[ppr (Peter Preuss)]

give a try on:

minDate | DateTime =

DT.AsEnumerable.Min(Function (x) DateTime.ParseExact(x("Date").toString.Trim, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture))