TRANSFORMER

NOP

NOP is a calculator function that calculates the number of periods between two dates.

 

Choose the field that is to contain the result in the Result Field drop-down list at the top, or create one by entering a new name.

 

Syntax   

NOP(<Start date>, <End date>, <Period>)

 

Examples

• NOP("2010-1-1", "2010-1-31", "D")    = 31, the number of days between Jan. 1, 2010 and Jan. 31, 2010

 

• NOP("2010-1-1", "2010-1-31", "M")    = 1, the number of months between Jan. 1, 2010 and Jan. 31, 2010

 

• NOP("2010-1-10", ${Date},"M")         gives the number of months between Jan. 1, 2010 and the date contained in the field called 'Date'

 

Version 5.1.2.0

This document contains confidential information. Not to be copied by third parties without written authorization.

© Copyright Corporater AS - All rights reserved.