Hi, I get stuck to build a query to select records between curdate() and the last 4 weeks and groupped by week. I tested with:
"SELECT * FROM momtbak WHERE insertdate BETWEEN curdate( ) AND curdate( ) - INTERVAL 4 week" It doesn't work. Please help, TIA. Willy Every why hath a wherefore. -- William Shakespeare, "A Comedy of Errors" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
