RowFilter on Date field





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


.



Relevant Pages

  • RowFilter on Date field
    ... I have loaded an xml file to a dataset and one of the fields being ... "UserDate" and has date values like ... Manoj Das ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • RowFilter on Date field
    ... I have loaded an xml file to a dataset and one of the fields being ... "UserDate" and has date values like ... Manoj Das ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • RowFilter on Date field
    ... I have loaded an xml file to a dataset and one of the fields being ... "UserDate" and has date values like ... Manoj Das ... Prev by Date: ...
    (microsoft.public.dotnet.general)
  • RowFilter on Date field
    ... I have loaded an xml file to a dataset and one of the fields being ... "UserDate" and has date values like ... Manoj Das ... Prev by Date: ...
    (microsoft.public.dotnet.academic)
  • Re: NEWB: reverse traversal of xml file
    ... I have an xml file of about 140Mb like this: ... I want to traverse it from bottom to top and add another field to each ... def enumerate_words: ... if prev>= part: ...
    (comp.lang.python)

Loading