Hi all,

I have dates coming from MySQL in this format:

yyyy-mm-dd (2006-01-16)

There are two dates 'startDate' and an 'endDate'. I need to be able to calculate the number of days between. For example, event is happening in 'x' days.

Now.... I could simply minus the startDate 'mm' from the endDate 'mm' but this won't work if the dates overlap months.

For example - 2006-01-24 and 2006-02-04. And another consideration is overlapping years as well.

Is there a function or something that can do this?

Thank you.