Feb 15, 2005 #2 TonyGroves Programmer Aug 13, 2003 2,389 IE Use the CURDATE() function. Upvote 0 Downvote
Feb 15, 2005 Thread starter #3 TGJ Programmer Jan 31, 2005 64 CA thanks, do you know how I can manipulate that to give me 30 days before todays date. Upvote 0 Downvote
Feb 15, 2005 #4 TonyGroves Programmer Aug 13, 2003 2,389 IE You could try R'ing TFM: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html Upvote 0 Downvote