Difference between two dates?

[#1]

Hi,

I have two dates stored in two object text.

I want to obtain the number of months between theses two dates?

How i proceed?

Thnks

[brenner_martina]

Hi,

use the expression month(field1)-month(field2)

[#3]

Hi,

The complete expression is:

(Year(End_Date)-Year(Init_Date))*12 + Num(Month(End_Date))- Num(Month(Init_Date))

Regards.

[#4]

use this

round((date1-date2)/30)