I have a problem in comparing dates and working out the difference between them.
I have tried various ways and although on the right track I'm sure a simple solution exists out there somewhere!!
Example: 01/01/1980 - 24/08/2009
I am tyring to find a simple way to accurately calculate difference and see the result in the format xx years, xx months and xx days.
Where several sets of From/To dates exist (possibly with breaks in between) I then have the problem of addind up sets of years months and days in order to get a final total number of years months and days (if that makes sence).
andyp