Auto-check date 'year' value for correct range.

Insert the formula below into the Input Validation for a Date/Time field. Returns a failure prompt if the year entered has a difference of more that 200 years.
Lotus Formula

@If(
fieldname = ""; @Success;
@Abs(@Year(testdate) - @Year(@Today)) > 100; @Return(@Failure("Dates must be between " + 
@Text(@Year(@Today) - 100) + " and " + @Text(@Year(@Today) + 100)));
@Success)

Posted by fbrefere001 on Monday April 9, 2001