Returns the date of the first day of the month coincident with or next following a date.

Syntax:

#NEXTBEGMTH date

Examples:

#NEXTBEGMTH 3/14/1967 equals 4/1/1967

#NEXTBEGMTH 2/1/1980 equals 2/1/1980

#NEXTBEGMTH 2/2/1980 equals 3/1/1980

This operator is useful for determining a normal retirement date. For example, if the field DOB contains the value 11/15/1936, then #NEXTBEGMTH (DOB #DATEPLUS 65y) returns 12/1/2001.

Related Operators:

#BEGMTH

#ENDMTH

#NEXTBEGMTH date is the same as 1 #MONTHROUND date.