Re: Select on datetime

2004-05-17 Thread Roger Baklund
* Ashley M. Kirchner > I have a table that has a datetime field that gets set every time > data gets entered in the table (for example "2004-05-16 19:08:59"). How > can I select all entries that were entered one year ago today. And, how > can I select entries that were entered one year ago to

Select on datetime

2004-05-17 Thread Ashley M. Kirchner
I have a table that has a datetime field that gets set every time data gets entered in the table (for example "2004-05-16 19:08:59"). How can I select all entries that were entered one year ago today. And, how can I select entries that were entered one year ago today +7 days. So, if tod