Results 1 to 24 of 24
Thread: Calculate Number of Days
Jan 16, 2006, 06:53 #1
- Join Date
- Jan 2005
- North America
- 0 Post(s)
- 0 Thread(s)
Calculate Number of Days
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?