Using date and time format

Double-click the required attribute in the right pane. A Column window is displayed.

Note:

The header of the window varies based on the attribute when creating an ASCII interface. For example, if you selected the entity End Time, the title is displayed as column End Time.
The column number is defaulted from the Interface Entry window based on the order in which the entities are selected. However, this value can be modified.

Select a style from the list to set year/month/date order. For example, 31/1/99 is date/month/year (DMY).

Select the separator check box and specify a character that is used to separate the years from months and days.

Note: You can specify a single character or an ASCII code that consists of at least 2 numerical digits (use a leading zero if the required ASCII code is between 0 and 9).

Select the leading zeroes check box if you require the month/day formats to read 01/01 instead of 1/1.

Select the century check box if you require year formats to read 1901 instead of 01.

If you want, select the date/time separator check box and specify a character that is used to separate the date part from a time part (if specified).

Note: You can specify either a single character or an ASCII code that consists of at least 2 numerical digits (use a leading zero if the required ASCII code is between 0 and 9).

Select a style option to define the base format of the time part of a date/time value, if any. For example, 01:45:30 is HMS.

Note: The time format entry is optional.

Select the separator box and specify a character that is used to separate hours, minutes and seconds. You can specify either a single character or an ASCII code that consists of at least 2 numerical digits (use a leading zero if the required ASCII code is between 0 and 9).

Note: You can specify a single character or an ASCII code that consists of at least 2 numerical digits (use a leading zero if the required ASCII code is between 0 and 9).

Select the leading zero check box if you require the time formats to read 01:45:30 instead of 1:45:30.

Note:

The example at the bottom of the window is updated automatically to display a date/time value formatted based on the current settings.
You cannot specify certain date/time combinations that can lead to ambiguity either in Infor Production Scheduling or in another system.

Select the quoted value check box to specify quotes around the data if you are interfacing with a system that requires inputs in the form value.

Click OK. The Entity tab of the Interface Entry window is displayed.