RowFilter on Date field

[Manoj Paramu Das]

I have loaded an xml file to a dataset and one of the fields being
"UserDate" and has date values like
<UserDate>2005-01-01T00:00:00.0000000-05:00</UserDate>
I am trying to apply a row filter to this field and it doesn't seem to work

dvCMonth.RowFilter = "Month(UserDate)=" & Now().Month

dvCMonth.RowFilter = "Month(UserDate)='4'"

no matter what I try, it doesn't work however, Any help would be appreciated
and thanks in advance.
Manoj Das

[Elton W]

Hi Manoj ,

Unfortunately DataView.RowFilter doesn’t support Month function. So you have
to use other way to figure it out. For example, you can try

dvCMonth.RowFilter = "UserDate >='1/" & Date.Today.Month.Tostring & "/" &
Date.Today.Year & "' AND UserDate < "'1/" &
Date.Today.AddMonths(1).Month.Tostring & "/" & Date.Today.Year & "'"

HTH

Elton Wang
el********@hotmail.com

"Manoj Paramu Das" wrote:

I have loaded an xml file to a dataset and one of the fields being
"UserDate" and has date values like
<UserDate>2005-01-01T00:00:00.0000000-05:00</UserDate>
I am trying to apply a row filter to this field and it doesn't seem to work

dvCMonth.RowFilter = "Month(UserDate)=" & Now().Month

dvCMonth.RowFilter = "Month(UserDate)='4'"

no matter what I try, it doesn't work however, Any help would be appreciated
and thanks in advance.
Manoj Das