Defining a custom date-and-time format
You can define a custom date-and-time format using special symbols, shown in Table 3-4, to construct a format pattern. Use custom date formatting only for reports viewed in a single locale. Custom formats always display dates in the format you set, which can be inappropriate in other locales. For example, if you use the format MM-dd-yy, the date January 10, 2006 always appears as 01-10-06, regardless of the locale in which you view the report. For locales that customarily display dates in date-month-year format, Interactive Viewer interprets the date 01-10-06 as October 1, 2006.
Table 3-4  
Table 3-5 shows examples of custom formats and their effects on a date stored as April 15, 2006 12:15:30 PM in the database.

Additional Links:

Copyright Actuate Corporation 2012