maggiemel
Posts: 75
|
| Posted: 01/10/2007, 10:28 AM |
|
Hello, all. I'm trying to offer my user's a choice whereby they can view records within the last week, month or year. They would like to choose using radio buttons.
I'm having a hard time figuring out how to construct the SELECT statement with a date parameter. I set up the values for my radio buttons to offer Week = 7, Month = 30, Year = 365, but I have no idea how to build the SELECT to do a DATEDIFF calculation (or some other equivalent method).
I ran across this post from Edd -- I tried to reconstruct this method using DATEDIFF, but I'm clearly doing something wrong.
http://forums.codecharge.com/posts.php?post_id=74903
Hopefully somebody can elaborate on this proposed explanation?
Many thanks in advance.
_________________
Melissa Cahill
http://www.hellcatmaggie.net/ |
 |
 |
|
