Datetime

Lets the user choose both a date and a time using either the keyboard input or by graphically selecting a date from a calendar and a time from a dropdown.

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

Start value: The date and time to display when the page loads or NULL to leave it blank.
Return value: The date and time chosen by the user or NULL if the user didn't select a date and time.
Supported in: NewEdit Parameter page Multirow

Appearance

alt text
In its closed state, the user can enter a date and time with the keyboard.


alt text
By clicking the calendar-icon, a date picker dialog is opened.


alt text
By clicking the clock-icon, a time picker list is opened.

Default value

SQL Call: Default value

Retrieves the default value for the control.

May modify database: No

Resultset: Default value

Table count: repeated exactly once
Row count: exactly one row
Columns
<column with ordinal 1> mandatory string
The default value

Validation

SQL Call: Validation

This call is only made if there is a field validation set for the field info and the field has any content.

Live Validation

Performs field validation when the user leaves the field or one of its dependencies is changed, initial values set by default value and initial values in edit-mode are not validated.

Save Validation

When saving the validation runs server side if the field value has changed. A field value is considered changed if in new mode the value is anything other than NULL. In edit mode it is considered changed if it has a value that was not returned by the GetEditFields procedure.

May modify database: No

Parameters

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

Resultset: Validation messages (optional)

Table count: 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.
Warning optional string
Warning message to display. Does not block saving.