This section can be used to specify conversions that should be applied to the data between the web page and the back-end system. For example, dates may be stored in a different format to which they are entered and displayed.The Data column represents the format of the data in the system, and any entered values will automatically be converted to this format when they are submitted. The Display column represents the value displayed on the web page and the system data will be converted to this format before it is displayed.The Date Formats options set the formats to be used for dates in the system. If the data type for this field is date, then the data date format must be specified. These fields accept date format strings in a similar way to the Java SimpleDateFormat class, e.g. dd/MM/yyyy. Please note that the display date format may contain the special character # in text input fields. This creates a dropdown box which allows users to easily select date parts. Please see the example below to see how to use this option. The table below describes the specific data conversion formats that are available.Table of Value Conversions available for Dates
Field
Full Form
Short Form
Year
yyyy (4 digits)
yy (2 digits), y (2 or 4 digits)
Month
MMM (name or abbr.)
MM (2 digits), M (1 or 2 digits)
NNN (abbr.)
Day of Month
dd (2 digits)
d (1 or 2 digits)
Day of Week
EE (name)
E (abbr)
Hour (1-12)
hh (2 digits)
h (1 or 2 digits)
Hour (0-23)
HH (2 digits)
H (1 or 2 digits)
Hour (0-11)
KK (2 digits)
K (1 or 2 digits)
Hour (1-24)
kk (2 digits)
k (1 or 2 digits)
Minute
mm (2 digits)
m (1 or 2 digits)
Second
ss (2 digits)
s (1 or 2 digits)
AM/PM
a
Examples:Table of example date format strings
yyyy-M-d
2006-10-15
dd MMMM yy
15 October 06
MM/dd/yyyy HH:mm:ss
10/15/2006 17:23:45
MM/dd/yyyy hh:mma
10/15/2006 5:23PM
The # symbol used in a date display format for a text input field will render the preceding date part into a dropdown box. For example the date format dd/MMMM#/yyyy will give:
/
/
The Case options set how the case of the data should be changed. The options are Preserve, Lower, Upper, Title and Sentence. Preserve leaves the case exactly the same, Title capitalises the first letter of each word in the string of data, and Sentence capitalises the first letter of the first word. Lower and Upper should be self-explanatory.The Whitespace option specifies how any whitespace entered in the value for this field should be treated. The values are Preserve, which leaves the data as entered, Collapse, which removes whitespace from the beginning and end of the string and then shrinks any group of whitespace characters to a single space, and finally Remove, which removes all whitespace from the entered string.The Calendar Popup section is an option that can be used for fields with a data type of date (see Data Constraints). If the checkbox is ticked, upon generating the page, a link will be created next to the field that will bring up a calendar window from which the user can select the date they require. This option should only really be used for Text Box type controls.The Calendar Type list shows the various selection and display methods for the calendar. These include the ability to navigate monthly or yearly, and to enter a value for the year. The Calendar Display Method option controls whether the displayed calendar will be shown in a completely new window (Popup window) or whether it should look like part of the existing page (In Page Display). The second option is often thought to look better, but may cause problems with older browsers if there are certain control fields (eg select boxes) in the vicinity.The Button Styling option allows a CSS class name to be specified for the calendar display button, that could be used to show a calendar image for example. For the default CSS file provided, the datePickerIcon class name should be used. The Button Text option allows us to specify the caption that should be used for the calendar popup button.
The Data column represents the format of the data in the system, and any entered values will automatically be converted to this format when they are submitted. The Display column represents the value displayed on the web page and the system data will be converted to this format before it is displayed.
The Date Formats options set the formats to be used for dates in the system. If the data type for this field is date, then the data date format must be specified. These fields accept date format strings in a similar way to the Java SimpleDateFormat class, e.g. dd/MM/yyyy. Please note that the display date format may contain the special character # in text input fields. This creates a dropdown box which allows users to easily select date parts. Please see the example below to see how to use this option. The table below describes the specific data conversion formats that are available.
Table of Value Conversions available for Dates