Home All Groups Group Topic Archive Search About

DataView RowFilter with dates (add n days to date)

Author
9 Jan 2006 8:34 AM
Kjetil Klaussen
Hi,

I have a DataView containing (among other things) two columns called DATE
(DateTime) and EXPIREINDAYS (Int32). Is it possible to filter rows from the
DataView based on whether rows are expired or not? The way I’ve tried to do
it is this;

myDataView.RowFilter = "(DATE + EXPIREINDAYS) >= #" + DateTime.Now.Date + "#";

But all I get is an exception telling me that adding DataTime and Int32 is
not allowed. Is there any AddDays() function that can be used for rowfilters?


--
Sincerely,

Kjetil Klaussen
Application Developer, Trondheim

AddThis Social Bookmark Button