Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
use the expression month(field1)-month(field2)
Hi,
The complete expression is:
(Year(End_Date)-Year(Init_Date))*12 + Num(Month(End_Date))- Num(Month(Init_Date))
Regards.
use this
round((date1-date2)/30)