I have a table with somedate defined as date.
I want to select all rows that are from todays date back to 7 daysago. Or in this case 10-1-1998.
data in the somedate fields appear as: 10-7-1998
Can someone help?
Thanks in advance