DateCompareType Enumeration

Specifies the date compare type.

Members

Member	Description
After	Indicates whether the date time is after a certain time.
AfterEqualsTo	Indicates whether the date time is after or equal to a certain time.
Before	Indicates whether the date time is before a certain time.
BeforeEqualsTo	Indicates whether the date time is before or equal to a certain time.
EqualsTo	Indicates whether the date time is equal to a certain time.
NotEqualsTo	Indicates whether the date time is not equal to a certain time.

Example

This example validates cell data.

Javascript

var nCondition = new GcSpread.Sheets.DateCondition(GcSpread.Sheets.DateCompareType.Before, new Date(2012, 11, 31));
var validator = new GcSpread.Sheets.DefaultDataValidator(nCondition)
activeSheet.getCell(0, 0, GcSpread.Sheets.SheetArea.viewport).dataValidator(validator);
spread.highlightInvalidData(true);
activeSheet.setValue(0, 0, new Date(2012, 12, 12));

Inheritance Hierarchy

Object
GcSpread.Sheets.DateCompareType

Reference

GcSpread.Sheets Namespace