Help with DataTable.Select

[buddyel]

I am trying to build a string to pass onto to a method that uses DataTable.Select and am running into an issue. The column i am trying to filter on is a datetime type. I tried using ColumnName = DateTime.Today but that returns nothing. I tried using between DateTime.Today and DateTime.Today.AddDays(1) but it throws an error saying "between" is not supported. How can i filter so that records with a Deadline of today are displayed? Any help is GREATLY appreciated.

 

[SHelton]

Try

dataTable.Select(string.Format("ColumnName > #{0}# AND ColumnName < #{1}#)", DateTime.Today.ToString("MM/dd/yyyy 00:00:00"), DateTime.Today.ToString("MM/dd/yyyy 23:59:59")))

 

[SHelton]

Oops, left a closing bracket in by mistake, should be:

dataTable.Select(string.Format("ColumnName > #{0}# AND ColumnName < #{1}#", DateTime.Today.ToString("MM/dd/yyyy 00:00:00"), DateTime.Today.ToString("MM/dd/yyyy 23:59:59")))

 

[buddyel]

Shelton,

The code works great, does exactly what I needed.

Thanks!