Technote Details :: Choose the database date format

The user interface allows setting the date format used in the database by choosing from a drop-down menu. Which one to select?

MX Dynamic Charts uses the selected date format to correctly recognize dates retrieved from the database, and used when grouping data after a date component (day, month, year).

The option you choose from the Date format drop-down menu (the Range tab) should be based on the date format used in the database.

The drop-down menu contains the following options:

• YYYY- - year/month/day as in 2005/
• dd-mm-YYYY - day/month/year as in 13/
• mm-dd-YYYY - month/day/year as in 01/

To select the exact database format as the one used by your database server, consult the server's user manual.

You can use all common date separators in your database, MX Dynamic Charts will know how to detect them when grouping the information.

Login to add a new note