Date

A time-picker component that lets users select a specific date and, optionally, a time.

Overview

Item	Details
Category	Date & Number
Sortable	Yes
Filterable	Yes
Available Filters	equals, not equals, empty, not empty, less than, greater than, ≤, ≥, in range, out of range

Settings

Setting	Description
Allow Empty	Set whether the field is required.
Placeholder when Empty	The placeholder text to display when the field is empty.
Use Current Time as Default	Enable to use the current time as the default value for the field.
Default Value	Set the default value for the field.
Include Time Picker	Enable to include a time picker in addition to the date picker.
Display Format	Set the display format for the date field.
Use Expression to Render	Enable to use an expression to customize the display value.
Disable Date when Expression	Set an expression to disable certain dates.

In Database

Field Type	Description
timestamp(6)	Stores the date and time.

Use Expression to Render

Can use an expression to customize the display value of the date field. For example, to display the date in the format "yyyy/MM/dd", use the following expression:

${Misc.formatDate(record.customDate,'yy/MM/dd')}

The above expression will render the following result:

24/07/17

Disable Date when Expression

Can use an expression to disable certain dates in the date picker. For example, to disable weekends, use the following expression:

${Date.datePart(date,'day_of_week')==6||Date.datePart(date,'day_of_week')==7}

The above expression will disable the following dates: