SSpread.TypeDateMin Property

In the date cell, set the lower limit of the date that can be entered.

Only valid for cells with the CellType property set to $CellTypeDate (date type). Before setting this property, use the Col , Row properties etc. to specify what you want to do.

Specify in YYYYMMDD format. The initial value is “19000101” .

Specify the upper limit with the TypeDateMax property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance of date type cells.

Points to note when specifying a range using lower and upper limits

Example of use

Col = 3;
Row = 2;
CellType = $CellTypeDate;
TypeDateMin = "20000101";
TypeDateMax = "20201231";
Value = str(sysdate(), "YYYYMMDD");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeDate;
TypeDateMin = "19500101";
TypeDateMax = "20491231";
Value = str(sysdate(), "YYYYMMDD");
BlockMode = $ FALSE;

Related item
CellType , TypeDateMax , TypeSpin , TypeSpinWrap property