I have a datagrid attached to a dataview attached to an SQL Server table that
uses datetime columns among other types.
The user gets to filter on various things in the table including the
datetime columns. I'd like to be able to use the rowfilter capability of the
dataview. However, I've run into t he well documented problem of the fact
that datetime columns include a time and therefore can't exactly match a
date.
As near as I can tell there is no provision for a calling functions in
rowfilters. Is that correct????
Thus as near as can tell, if you want to exactly match column dat for date
1/1/2005
regardless of the time you have to write dat>= '1/1/2005' and
dat<'1/2/2005'. Is this correct???? Is there any better solution????
--
Regards,
Al Christoph
Senior Consultant and Proprietor
Three Bears Software, LLC
just right software @ just right prices @3bears.biz