-
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:
-
Re: Rowfilter and Dates
Code.
+
You can ask on .net forum, i think it's a .net issue (and we are only a dozen here in the mobiles :) )
-
Re: Rowfilter and Dates
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.
-
Re: Rowfilter and Dates
Yes u are using mobile but in Visual studio :)
Anyway, try to do a "cast" as datetime on the date.