Date and Datetime fields formatting

The default format for date/datetime fields in Form/columns in Grid is the one specified in the PASOE configuration file, in these fields:

• globalDateFormat - %d.%m.%Y
• globalDateTimeFormat - %d.%m.%Y %H:%i

For displaying dates, there are datefields in Form/Grid which have an attached Datetimepicker to them on the left side.

There are two attributes for these fields that are important:

DATA-TYPE attribute

Specifies if the field is ‘date’ or ‘datetime’. The accepted values are ‘date’ for date and ‘datetime-tz’ for datetime.

extendedFormat attribute

A custom format can be specified by setting the ‘extendedFormat’ attribute in the corresponding field. If the attribute is set, it will overwrite the default values (the ones specified in the PASOE configuration file).

The ‘extendedFormat’ attribute can be specified using the following characters:

• %d - day as a number with leading zero, 01..31
• %m - month as a number with leading zero, 01..12
• %Y - year as a number, 4 digits
• %H - hours 24-format with leading zero, 01..24
• %i - minutes with leading zero, 01..59