The number of months between date1 and date2. The function calculates the difference by subtracting the month number of date1 from the month number of date2. For example, if date1 is 8/1/08 and date2 is 8/31/08, DIFF_MONTH( ) returns 0. If date1 is 8/25/08 and date2 is 9/5/08, DIFF_MONTH( ) returns 1.The following example calculates the number of months between each value in the askByDate data field and each value in the ShipByDate data field:The following example calculates the number of months from each value in the hireDate data field to the end of the year:


Copyright Actuate Corporation 2012 