Modifying Server Date Formats

Interactive Reporting Studio uses the default formats specified by the database server when handling date, time, and timestamp values. If the default formats of the server have been changed, you can adjust preferences to ensure that Interactive Reporting Studio interprets date/time value

  To modify server date formats:

  1. Select Tools, and then Connection, and then Create.

    The Database Connection Wizard is displayed.

  2. Select Show Advanced Options, then Next.

  3. Click Server Dates.

    The Server Date Formats dialog box is displayed.

    • To Server Formats—Date and time formats submitted to the server (such as limit values for a date or time field).

    • From Server Formats—Formats Interactive Reporting Studio expects for date/time values retrieved from the server.

    • The default values displayed in the To and From areas are usually identical.

  4. If the server defaults have changed, select the date, time, and timestamp formats that match the new server defaults from the To and From format drop-down boxes.

    If desired, click Default to restore all values to the server defaults stored in the Interactive Reporting database connection file.

  5. If you cannot find a format that matches the database format, click Custom.

    The Custom Format dialog box is displayed.

  6. Select a data type from the Type drop-down box.

  7. Select a format from the Format drop-down box or type a custom format in the Format field.

  8. Click OK.

    The new format is displayed as a menu choice in the Server Date Formats dialog box.