datedif problem

[Legacy 65404]

Hi all... I think I have a problem....

I used a datedif between the dates: 03/11/1986 and 03/10/1988, and it returned me 1 year, 11 months and 28 days!!! (it should return 29 days!!)

when I tested, I put between 03/11/1986 and 03/11/1988 and returned 2 whole years, what is correct...

It may have happened because 1986 is a leap year... but I don't know what to do...
do you guys have any clue??

thx all in advance...

(please help...)

 

[barry houdini]

If you are expecting 1 day short of 2 years to always be 1 year 11 months and 29 days then that isn't going to happen with DATEDIF, depending on your dates you could get 27, 28, 29 or 30 days.

DATEDIF doesn't treat a month as 30 days, it looks at the actual number of days so, of course, because months are variable lengths you won't get consistent results.

What are you trying to do?

 

[Legacy 65404]

****.. I actually saw what happened, it was as you said, barry... because feb has 28 days, after the 27th of the 11th month, we get 2 years...

thanks... i guess this is the way it was supposed to be

 

[mortgageman]

If you are expecting 1 day short of 2 years to always be 1 year 11 months and 29 days then that isn't going to happen with DATEDIF, depending on your dates you could get 27, 28, 29 or 30 days.

DATEDIF doesn't treat a month as 30 days, it looks at the actual number of days so, of course, because months are variable lengths you won't get consistent results.

What are you trying to do?

And this is why what I was suggesting wouldn't work either.
Gene, "The Mortgage Man", Klein