We run many queries for data for the previous day.. select foo from blah where date=(Current_Date)-1;
Since it was just the end of the month that ended up giving us a blank result set. I looked through the manual but I didn't find an answer. (I probably just looked over the right part) Does anyone know how we can run this type of query and have it also select the right day? Thanks, Jeff O'Neal Quality Engineering [EMAIL PROTECTED] "If you think you can or you think you can't.... You're right" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
