createDateValidator Method

Creates a validator based on the data.

Syntax

Javascript (Usage)
Javascript (Specification)

var value; // Type: DefaultDataValidator
value = GcSpread.Sheets.DefaultDataValidator.createDateValidator(typeOperator, v1, v2);

function createDateValidator( 
   typeOperator : ComparisonOperator,
   v1 : object,
   v2 : object
) : DefaultDataValidator;

Parameters

typeOperator: The type of ComparisonOperator compare operator.
v1: The first object.
v2: The second object.

Return Value

The validator.

Example

This example creates a data validator.

Javascript

spread.highlightInvalidData(true);
var dv = GcSpread.Sheets.DefaultDataValidator.createDateValidator(GcSpread.Sheets.ComparisonOperator.Between, new Date(2012, 11, 31), new Date(2013, 11, 31));
dv.showInputMessage = true;
dv.inputMessage = "Enter a date between 12/31/2012 and 12/31/2013.";
dv.inputTitle = "Tip";
activeSheet.getRow(1).dataValidator(dv);

Reference

DefaultDataValidator type