The following rules are applicable for both form fields and grid cells.
The default format for numeric fields in Form 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 which have an attached Datetimepicker to them on the left side.
There are two attributes for these fields that are important: DATA-TYPE and extendedFormat.
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
| Info | ||
|---|---|---|
| ||
|