elapsed between 2 dates

[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

[Cor Ligthert [MVP]]

Re: elapsed between 2 dates

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

"Jose" <josenospam@uni ca.com> schreef in bericht
news:uXCeJVCjGH A.4044@TK2MSFTN GP03.phx.gbl...[color=blue]
> 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
>
>
>
>[/color]

[Michel Posseth [MCP]]

Re: elapsed between 2 dates

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]



"Cor Ligthert [MVP]" <notmyfirstname @planet.nl> schreef in bericht
news:ecB02AFjGH A.1272@TK2MSFTN GP03.phx.gbl...[color=blue]
> 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
>
> "Jose" <josenospam@uni ca.com> schreef in bericht
> news:uXCeJVCjGH A.4044@TK2MSFTN GP03.phx.gbl...[color=green]
>> 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
>>
>>
>>
>>[/color]
>
>[/color]