Translations:Expressions/55/en

From TaticView
Jump to: navigation, search

Num of months

Return the number of months between two dates.

   Syntax: NUM_OF_MONTHS(<expression_date1>;<expression_date2>). Need two date data type parameters. 
 Examples: NUM_OF_MONTHS(FIRST_DAY_OF(0;"Date");"Date") - Return the number of months between the first day of the year of the "Date"
           column and the current month of the "Date" column;