Skip to main content

Date

Date with calendar look-up

Properties

  • Type: Basic
  • Groupable: Yes
  • Show in lists: Yes
  • Searchable: Yes
  • Requires configuration: No

User interface

Field in show mode

image.png

Field in edit mode

image.png

Configuration

image.png

Show mode

The date will be formatted as defined in format option.
Default formatting is: dd/mm/yyyy

Edit mode

The date field will display a textbox. On activating the field a date selector will popup below the field.
Normal input format is: dd/mm/yyyy

The values for dd and mm can be either 1 or two digits - examples

  • 1/12/2013 or 01/12/2013
  • 31/1/2013 or 31/01/2013

The separator method is also free: "/" or "-" will do

Other options

The date field can be set to strict or loose date parsing:

  • Strict: Only the correct date format supplied by the date selector dd/mm/yyyy
  • Loose: Interpretation of all values
    • 31/12 > 31/12/[this year]
    • 311213 > 31/12/2013
    • 30 > [30 days from now]
    • -7 > [7 days ago from now]

The loose option is activated by setting the configuration (policy): doSmartDateInput

Developer info

  • FeltTypeID: 20
  • SQL datatype: DATE
  • Class name: FieldTimeDate
Back to top