Formatting Date Constants

You can enter an unformatted date in most PeopleSoft pages. For example, in most pages the system automatically reformats 01011004 (January 1, 2004) as 01/01/2004. However, if you enter an unformatted date in one of the Operand fields, the system treats it as a number. To tell the system that the eight digits represent a date and not a number, either:

• Include a separator (a slash, dash, or space) when you enter a date, or

• Select the Date check box under the operand.

Note:

The Custom Statement page requires you to enter eight-digit dates that include the century in the year. This is different from most PeopleSoft pages, which accept six-digit dates. For example, in the Custom Statement page, enter January 1, 2005 as 01/01/2005, not as 01/01/05.

When you use a date alias, there's no reason to select the Date check box. The system already knows the value is a date and formats it appropriately.