Date

[DESCRIPTION]

Properties

• Type: Basic
• Groupable: Yes
• Show in lists: Yes
• Searchable: Yes

User interface

Field in show mode

[INSERT IMAGE]

Field in edit mode

[INSERT IMAGE]

Configuration

[INSERT IMAGE]

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/[Eventuelthis beskrivelseyear]
  af
  • 311213 configs]> 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