SSpread.TypeDateSeparator Property

Set the year-month-day separator in a date type cell.

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 process.

The delimiter specifies the Unicode character code as a number. Set to 47 ( 0x2F , ‘/’ ) if you want to use forward slashes . Do not specify illegal characters that cannot be displayed correctly, such as control characters and special characters.

If set to 63 ( 0x3F , ‘?’ ), “year, month, day” will be the delimiter. If 0 is set, the OS setting value is set.

The initial value is the OS setting value. The date format is set with the TypeDateFormat property.

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

Use case

Col = 3;
Row = 2;
CellType = $CellTypeDate;
TypeDateSeparator = 0x3F; / *'?' * /
Value = str(sysdate(), "YYYYMMDD");
 
BlockMode = $ TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeDate;
TypeDateSeparator = 0x2D; /* '-' */
Value = str(sysdate(), "YYYYMMDD");
BlockMode = $ FALSE;

Related item
CellType , TypeDateFormat property