Forum Moderators: open

Message Too Old, No Replies

.Net datetime filters - help please

My filter isn't working....

         

RossWal

10:38 pm on Jan 29, 2004 (gmt 0)

10+ Year Member



I'm unable to filter on a datetime column using the datarow view.

Here is the XML as it is stored in the file:
<StartDate>2003-12-16T11:32:18.8743750-08:00</StartDate>

Here is the data coming out of the dataset:
12/16/2003 11:32:18 AM

Here is my filter:
StartDate = #12/16/2003 11:32:18 AM#

Apparently it doesn't match the filter to the data... I never get a match. I'm guessing it has to do with the -08:00 in the xml, which I take to be an offset to GMT. Filtering on regular text fields works fine.

Any thoughts?

Ross

Xoc

10:42 pm on Jan 29, 2004 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



No, I think it is the .8743750 of a second that is not matching. You either need to have this in the filter, or not have it in the xml file.