How to use DataView.RowFilter when the property is DateOnly

Question

How to use DataView.RowFilter when the property is DateOnly

LXY 20

Does the RowFilter support DateOnly type property?

How to filter DataRow by DateOnly 's value?

Accepted answer

1 additional answer

Your answer

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

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.

LXY 20 Reputation points

2024-08-22T04:14:18.6166667+00:00

It does not work in C#.

my code:

DateOnly sDate = new DateOnly(2020,1,1);

dataView.RowFilter=$"Convert(Hiredate,'System.DateOnly') like '{sDate}%'";

but it reports the error:System.Data.EvaluateException:“Cannot perform 'Like' operation on System.DateOnly and System.String.”
Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2024-08-22T05:32:09.34+00:00
Hi @LXY ,

In C#, you can use the following code.

dataView.RowFilter=$"CONVERT([Hiredate], 'System.String') LIKE '{sDate}%'";

Answer 2

Viorel 122.6K

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).

LXY 20 Reputation points

2024-08-21T18:52:18.6633333+00:00

I know this,but it is incorrect.

It report a error:System.Data.EvaluateException:“Cannot perform '<' operation on System.DateOnly and System.DateTime.”

Share via

How to use DataView.RowFilter when the property is DateOnly

1 additional answer

Your answer