RowFilter on Date field

  • Thread starter Thread starter Manoj Paramu Das
  • Start date Start date
M

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date error 2
.NET Webservice - DateTime XML serialization wrong? (please help) 0
XML dateTime conversion to DateTime.MinValue accross timezones 0
XSLT Transformation DateTime 1
DateTime Null value in Typed DataSet gives Invalid Cast Exception - Please help !!! 2
Getting MM-DD HH:MM out of Julian date 4
Converting european date format to US format. 2
GetXML and date format 1

Back
Top