Date formats

In order to better display date and time, MX Kollection 3 allows you to set the formats used in the database and in the browser. These options can be set from the InterAKT Control Panel, in the Date Formats section.

With the dialog box options you can set the date format for the database, and for the application pages.

The database format is the format you use for storing, editing and retrieving date information in and from your database. The database format is not detected automatically from your current database settings or design. You should know how date and time are stored in your database, then select the same for the database format in the InterAKT Control Panel. If the database format specified in the control panel is different from the database format actually used, your application may crash or information may become incorrect or corrupt.

The screen format is the format used for displaying date and time information from the database in your web applications. This is the also the format that users of your applications will have to use when filling in web forms. The screen format is translated into database format and vice-versa, depending on your actions. You should remember that the database format is the way you store information, while the screen format is the way you see information.

The user interface is organized into two sections: one regarding the database date and time formats, and one referring to the screen date and time formats (the formats used on page).

To set the dialog box options, follow the next steps:

1. In the Date format drop-down menu (of the database section) select the format used in the database.
2. In the Time format drop-down menu (of the database section) select the format used by the database to store the time.
3. In the Date format drop-down menu (of the screen section) select the way you want to display dates in your pages.
4. In the Time format drop-down menu (of the screen section) select the format to use when displaying time on your pages.
5. The three buttons on the right of the interface offer you the next functionality:
   · Click OK when you are done configuring the dialog box.
   · Click Cancel to exit without changing the date formats settings.
   · The Help button takes you to this help page.

The characters used in date formats mean the following:

• d: Day of the month as digits, without leading zero for single-digit days.
• dd: Day of the month as digits, with leading zero for single-digit days.
• m: Month as digits, without leading zero for single-digit months.
• mm: Month as digits, with leading zero for single-digit months.
• yy: Year as last two digits.
• yyyy: Year represented by four digits.

The characters used in time formats mean the following:

• h: Hours, without leading zeros for single-digit hours (12-hour clock).
• hh: Hours, with leading zeros for single-digit hours (12-hour clock).
• H: Hours, without leading zeros for single-digit hours (24-hour clock).
• HH: Hours, with leading zeros for single-digit hours (24-hour clock).
• mm: Minutes, with leading zeros for single-digit minutes.
• ss: Seconds, with leading zeros for single-digit seconds.
• t: One-character time marker string, such as A or P (for ante-meridian, and post-meridian).
• tt: Two-character time marker string, such as AM or PM (for ante-meridian, and post-meridian).