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”.
This works fine with Data 1 (returned 1 row), but not with Data 2 (return 0 row).
Data 2 (notice Data 2 has some rows with empty Access Date):
Could anyone suggest me:
- Why this happened?
- How to handle this?
Sample .xaml and Excel files:
Select Date.zip (18.1 KB)