|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DataView RowFilter with dates (add n days to date)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 |
|||||||||||||||||||||||