MBT_OPERATOR
Back to current versionRestore this version

MBT - Months Between #

This operator takes the months between Operand 2 and Operand 3 and stores the result in Operand 1. The value stored in Operand 1 will be either a positive or negative value.

The number of months will be expressed as a fractional number.

Statement: If an employee has worked more than 3 months for the company and their employment status is still listed as ‘Probation’, issue a warning to the Exception Report.

LineCMDOTOperand 1OPEROTOperand2OTOperand3If Goto Else GoTo
00010 LETVMONTHS SERVICEMBTDBEEM.HIRE_DATE$SPERIOD-END-DATE00020
00020 IFVMONTHS SERVICEGEN3 00100 99999
00100IFDBDES.STATUS_CODEEQAPROBATION 00200 99999
00200 MSGAEE STATUS S/B ACTIVE 99999
99999 EXIT 99999