Date validations from a data table

[chauhan.rachita30 (Rachita30)]

Hi, I have this excel with Dates Valid column with 2 dates separated by “-” , I need to verify that all rows have dates and the first date (date before the “-”) is less than the second date:

How can I write this expression in a single line?
Thanks for the help.

[Yoichi]

HI,

How about the following sample?

arrDr = dt.AsEnumerable.Where(Function(r) not (DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value,New DateTime) AndAlso DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value,New DateTime) AndAlso DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value) < DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value) )).ToArray

Sample
Sample20240909-1.zip (9.7 KB)

Regards,

[Raj_esh (RM)]

Hi

Try this,

[chauhan.rachita30 (Rachita30)]

Thank you for the help

[chauhan.rachita30 (Rachita30)]

can we add a check that the table doesn’t contain null in any of the rows to the same expression?

[Yoichi]

Hi,

Can you try the following sample?

dt.AsEnumerable.Where(Function(r)  r.ItemArray.Any(Function(o) o is Nothing OrElse String.IsNullOrEmpty(o.ToString)) OrElse not (DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value,New DateTime) AndAlso DateTime.TryParse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value,New DateTime) AndAlso DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,".*(?=-)").Value) < DateTime.Parse(System.Text.RegularExpressions.Regex.Match(r("Dates Valid").ToString,"(?<=-).*").Value) )).ToArray

Sample
Sample20240909-1 (2).zip (9.8 KB)

Regards,