Date Picker

Add a calendar to display date and time in a variety of formats.

The calendar allows you to select specific date and time to use with queries and other data in the end application. All time related queries can make use of the date and time selection.

The date picker widget is available under INTEGRATION > GENERAL. When designing application pages, drag-and-drop GEDatePicker to a container.

Specify these plug-in properties:

Note: When configuring input targets for plugins, ensure that no other binding exists for the target query input. To remove a binding from the query input, select the unlink icon next to the binding.

The following list of properties are specific to this widget. For common properties, refer to Page Components (Classic).

DatePicker Properties

Field Name Description
Title Provide the text that appears as a label above the plug-in in the end application.
Type Select from these options for display in the end application:
  • date: displays only date
  • time: displays only time
  • datetime: displays both date and time
Display Format Select the format for the date and time display.
Note: If date picker output is used as an input for any of the extension type queries, then choose only these display formats:
  • yyyy-MM-dd HH:mm:ss (24 hour)
  • yyyy-MM-dd hh:mm aa (12 hour)
Custom Display Format Use this option to define any specific date format. Enter a format string that defines the pattern for displaying the date.
Output Format Choose from:
  • ISO: The selected date is formatted as per the ISO 8601 standard, which follows the pattern "YYYY-MM-DD". For example, if the selected date is May 18, 2023, the formatted output will be "2023-05-18".
  • Match Display Format: The selected date is formatted in the same way as it is displayed in the date picker. For example, if the date picker display format is "MM/DD/YYYY", and the selected date is May 18, 2023, the formatted output will be "05/18/2023".
Local UTC
ISO
  • Appends Z and time shift to UTC by DatePicker
  • No time shift by the Operations Hub Server
  • Appends Z and time shift to UTC by DatePicker
  • No time shift by the Operations Hub Server
Match Display Format This is the recommended setting to avoid time shift by the DatePicker.
  • Sent “as is”
  • No time shift by the Operations Hub Server when the SQL query Convert Datetime is unchecked.
  • Time shift to UTC by DatePicker
  • No time shift by the Operations Hub Server when the SQL query Convert Datetime is unchecked.
Refer to Create SQL Query (Classic).
Timezone Select the timezone as local or UTC. This property works in conjunction with the output format options (ISO, Match Display Format). It determines whether the selected date will be converted to your local time zone (or) if it will be converted to UTC, which is a standardized global time reference.
Note: For Historian sources, use 'local' for timezone.
Source Input Value Set this value to allow the plug-in to start displaying a specific date and/or time when it loads in the end application.
Input Target This is the value the plug-in provides as an output in the end application. For example, you can choose a date/time/datetime that is passed to the query, which requires a date time.
Hidden Select this check box if you want to hide the plug-in. To show the hidden plug-in in Operations Hub new layout, go to Page Visuals and under Action column, select for the hidden plug-in. See Page Visuals Tab.

Date Picker at Runtime