Sqldatasource WHERE with dates question
Posted on 2010-09-03
I am trying to do something that I thought would be simple but it doesnt seem to be. I have a date field stored in SQL. I want to create a sqldatasource linked to a gridview with a where clause so it will only display the row if the date is within 7 days of the current date. So as soon as the value is over a week old, it gets removed from the gridview. I have tried everything I can think of but it either says I am comparing a date to a string or gives me syntax errors. Can someone tell me how to do this? Thank you.