DateDiff() Function

L

ltamisin

Hi to all

Im working in a DateDiff() function right now, my question is how can I get
the total Year, Month and Day ? can you give me the formula on how to get
the total Year, Month and Day.

Field1: 11-05-81
Field2: 31-05-05

DateDiff()
Field3: Total Year
Field4: Total Month
Field5: Total Days

Thanks
 
D

Dennis

Datediff will only return 1 calculation dependant on what you specify. You
will therefore have to do 3 calculations for year, month and days difference
and manually work it out yourself.
 
Top