I have this gridview and using this filterexpresson thing.
So I pass the where statement to gridview and I am trying to compare date field.
I am trying to look for past dated items.
Find 60 days past due from today:
Select * from orders where [expiratiodate] < getdate()-60;
This works find in SQL but doesn't work with the C# gridview.
HOw can fix this so it will work?
Gridview.FilterExpresson = "[expirationdate] < GetDate() - 60"
[expirationdate] field is Smalll Date field in sql.