HOW to filter by Hour using DataView.RowFilter ?

[David]

Hi, I use DataView to filter my record.
But when I use:

ls_filter += " and DATEPART(hh, CA103)=" + i ;
mydv.RowFilter = ls_filter;

I got error.

How should I filter by hour using DataView.Rowfilter?

Thanks for kind advice, David.

[Peter]

Hi David,

You could return the DATEPART of you datetime column as a seperate column in
your original SQL query. You could then filter by this field very easily in
your DataView's RowFilter.

e.g Instead of:

SELECT TheDateColumn FROM TheTable

do this:

SELECT TheDateColumn, DATEPART(month, TheDateColumn) AS [MonthFilterCol]
FROM TheTable

Regards,

Peter

"David" wrote:

Hi, I use DataView to filter my record.
But when I use:

ls_filter += " and DATEPART(hh, CA103)=" + i ;
mydv.RowFilter = ls_filter;

I got error.

How should I filter by hour using DataView.Rowfilter?

Thanks for kind advice, David.

[David]

Thank you for your quickly reply, Peter.

David.