Applying a date-and-time format You can choose from several common formats to display date-and-time data. You can, for example, display dates as January 19, 2008 11:00:00 AM PST; Jan 19, 2008; or 1/19/08, and so on. This section describes how to select standard and custom date-and-time formats. How to apply a date-and-time format 1 Select a column that contains date-and-time data. 2 From the context menu, choose Format→Format Data. 3 On Date column format, select one of the formats from the list. You can select a standard format or define a custom format. The standard and custom formats are described in the next sections. If you select a standard format, proceed to step 4. If you select a custom format, specify a format code in the next drop-down list, then proceed to step 4. 4 Select a locale from the next drop-down list. Choose OK.
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy