elapsed between 2 dates

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

How obtain the years,months and days for two dates?
For example:
dateini = 08/05/2005
datefin=09/06/2006

result = "1 año, 1 meses, 1 dia"

Thanks a lot. I used to vb.net 2003
 
Jose,

You have asked this before while I thought 5 persons have answered you on
that is there not any reaction from you on your question.

Is this a game from you?

Cor
 
Well here is the sixth answer

use the datediff function to calculate the time difference in the units you
require
now calculate yourself how manny hole years this differnce value is now
subcalculate from the rest , the number of months and from the rest of this
value the number of days

:-)

Simple isn`t it ???


regards

Michel Posseth [MCP]
 
Back
Top