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

[Marina]

I am not sure that RowFilter supports the Month function. Check the
documentation, it says exactly what is supported. You may end up needing to
parse the string in the filter to get the month out, which is going to be a
pain.

"Manoj Paramu Das" <ma*******@msn.com> wrote in message
news:e0*************@TK2MSFTNGP15.phx.gbl...

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