Rowfilter and Dates

Hi,

I am reading an xml file into a dataset and then trying to filter the records on a date field.

The date in the xml file looks like this:

<sdate>2007-19-17T00:00:00+01:00</sdate>

Whatever way I try and use the rowfilter method it return 0 items.

How do you filter on a date?

Thanks.:thumb:

Code.
+
You can ask on .net forum, i think it's a .net issue (and we are only a dozen here in the mobiles :) )

Code is:


strFilterString = "sdate = '17/09/2007'"
dsRecSet.Tables("SelectTable").defaultview.RowFilter = strFilterString

I should have 18 records however the code:

dsRecSet.Tables("SelectTable").defaultview.count = 0

I am using VB 2005 with a device application so the application is running on my Pocket PC phone.

Yes u are using mobile but in Visual studio :)
Anyway, try to do a "cast" as datetime on the date.