Re: Urgent DATA help needed

Chris Payne wrote:

Could anyone show me an example of how to do this? So to take 2001-07-05 and add 3 days to it?

To use SQL to do this:

SELECT FROM_DAYS((TO_DAYS('2001-07-05') + 3));

The TO_DAYS and FROM_DAYS are nice functions to use when you are fildling with dates as numbers (i.e. doing arithmatic operations to the dates). There are also a bunch of other function dedicated to do math operations to date and they are listed here: http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html