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