data view row filter and SQL commands like DATEDIFF?

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

Can you use sql server commands like this

dv.RowFilter = "datediff(d, OrderDate, getdate()) >= 2850 "


in a row filter? or will i have to do it another way? thanks!
 
For a list of functionality go see DataColumn.Expression help topic.
And I don't think you'll be able to achieve that. Perhaps you might add a
"manually" calculated column which would store days (you would fill it with
your code) and do filtering on that row.
 
Back
Top