>>In SQL Server I got

>>declare @d datetime = '2009-09-15 10:40:20'
>>
>>select DATEDIFF(year, @d, CURRENT_TIMESTAMP) as [Years], 
>>DATEDIFF(month, @d, CURRENT_TIMESTAMP) as [Months], 
>>DATEDIFF(day, @d, CURRENT_TIMESTAMP) as [Days]

>>
>>2, 25, 749
>
>Can you try with:
>
>

>        Dim earlierDate As New DateTime(2007, 8, 5, 10, 15, 0)
>

>
>And, tell me the numbers you get?

Years	Months	Days
4	50	1521