How to use DataView.RowFilter when the property is DateOnly

Question

Does the RowFilter support DateOnly type property?

How to filter DataRow by DateOnly 's value?

Answer 1

Hi @LXY ,

DataView.RowFilter does not directly support the DateOnly type since RowFilter works with string representations of data types like DateTime.

Convert both the column values and DateOnly to strings and then compare.

Dim filterDate As DateOnly = DateOnly.FromDateTime(New DateTime(2024, 8, 22))
myView.RowFilter = $"CONVERT([YourDateColumn], 'System.String') LIKE '{filterDate}%'"

Best Regards.

Jiachen Li

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

For example, you can write "Birthdate < #1/31/2006#" (https://learn.microsoft.com/en-us/dotnet/fundamentals/runtime-libraries/system-data-datacolumn-expression#user-defined-values).