I have dates coming from MySQL in this format:
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?