 |
|
|
|
|
|
|
|
|
2006-12-01, 12:12 PM
|
#2 |
|
a.k.a. Sparky
Join Date: Sep 2004
Location: West Palm Beach, FL, USA
Posts: 2,396
|
select if('2006-11-01'>date_sub(curdate(),interval 7 day),'within the last week','more than a week old');
something like that will work. substitute your field name in the place where I put the date
__________________
SnapReplay.com a different way to share photos - iPhone & Android |
|
|
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode