Control: Date

 Show all Hide all

Lets the user choose a date either by keyboard input or by graphically selecting the date from a calendar.

The supported keyboard input and display formats are controlled through language phrases 90560 and 90561 which are visible and editable in all projects.

Start value: The date to display when the page loads or NULL to leave it blank.
Return value: The date selected by the user or NULL if no date is selected. The time part will always be set to 00:00.

Control container: NewEdit

Supported in: NewEdit Parameter page Multirow

Default value

SQL Call: Default value

Retrieves the default value for the control.
Supports custom errors: No
May modify database: No

Resultset: Default value

Repeat mode: repeated exactly once
Row count: exactly one row

Columns:

<column with ordinal 1> mandatory string
The default value

Validation

SQL Call: Validation

Performs field validation when the user leaves the field or one of its dependencies is changed. This call is only made if there is a field validation of type SQL set for the field info.
Supports custom errors: No
May modify database: No

Parameters:

@Value mandatory string
The value of the field, the procedure will not be called if value is NULL.

Resultset: Validation messages

Repeat mode: repeated zero or one time
Row count: zero or one row

Columns:

Error optional string
Error message to display. Blocks the user from saving.
Info optional string
Informative message to display. Does not block saving.