Formatting Date Constants

On most PeopleSoft pages, you can enter an unformatted date. For example, you can enter 01012008 for January 1, 2008, and the system automatically reformats your entry to 01/01/2008. There is no need to enter the slashes or any other separator.

However, if you enter an unformatted date into one of the operand fields, the custom statement treats it as a number. In order to indicate that the eight digits actually represent a date and not a number, select the Date check box beneath the operand. This is only necessary when you enter unformatted dates. If you include a separator (a slash, dash, or space) when you enter a date, you do not have to select this check box.

Note:

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

When you use a date alias, there is no reason to select the Date check box; the system already knows the value is a date and has formatted it appropriately.