Formula showing tenths of a month instead of days

[cjbrown815]

Hello,
I have a formula that shows 1.4 MOS (MONTHS). Is ther a way to get the actual month and number of days? thanks

datetimevar d1:={SAMPLE.DATE3};
datetimevar d2:={SAMPLE.DATE1};
totext(Datediff("n",d2,d1)/60 /24 /30,1,"") & " MOS"

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[IanWaterman]

This part of the formula gives you difference in minutes

Datediff("n",d2,d1)

Create a new formula with

Datediff("d",d2,d1)

This gives you difference in days.

Ian