Data Table - Select row

[Divyashreem (Divyashree Muddagangaiah)]

Select Returns No Row When There Is An Empty Value in Select Column

Scenario: Hello, I want to take all rows from Excel data only where the “Access Date” Column is today. This is my code: dt1.Select(string.Format(“[Access Date] = '”+todayDate+“'”)) where todayDate was “2018/01/25”. Problem: This works fine with Data 1 (returned 1 row), but not with Data 2 (return 0 row). Data 1: [Data1] Data 2 (notice Data 2 has some rows with empty Access Date): [Data2] Question Could anyone suggest me: Why this happened? How to handle this? Attached: Sample .xam…