On Fri, Jan 10, 2003 at 12:35:37 -0800,
Hunter Hillegas <lists@lastonepicked.com> wrote:
> I am trying to calculate the number of days between two dates.
Just subtract the dates from each other. The result will be an integer type
with the number of days between the two dates.
> date_shipped: 2002-12-16
> date_of_request: 2002-10-29
> date_difference: 18
> NOT OK - it is more days than this.
You are just comparing the days of the month, not the actual days.