Using a Date/Time Dialog Box

This dialog box is displayed when creating an ASCII interface and selecting the Entity tab.
  1. On the Entity tab, double-click an attribute in the right pane.
    A Column dialog box is displayed.
    Note:  The header of the dialog box changes based on the attribute when creating an ASCII interface. For example, if you selected the entity End Time, the title would be column "end time."
  2. The column number defaults from the Interface entry window based on the order in which the entities were selected, but can be changed.
  3. Select a style from the list box or the date format to set year/month/date order. For example, 31/1/99 is date/month/year (DMY).
  4. If you want, select the date separator check box and choose a character to separate the years from months and days. You can enter 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).
  5. Select the leading zeroes check box if you want month/day formats to read 01/01 instead of 1/1.
  6. Select the century check box if you want year formats to read 1901 instead of 01.
  7. If you want, select the date/time separator check box and enter a character to separate the date part from any time part you may choose to define. You can enter 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).
  8. If you want, 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.
  9. If you want, check the date separator box and choose a character to separate hours, minutes and seconds. You can enter 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).
  10. Select the leading zero check box if you want time formats to read 01:45:30 instead of 1:45:30.
    Note: 
    • The example at the bottom of the dialog box updates automatically to show a date/time value formatted according to the current settings.
    • You are prevented from entering certain date/time combinations that could lead to ambiguity either in Infor Production Scheduling or in another system. This is not something that you would normally notice.
  11. Select the quoted value check box to put quotes around the data if you are interfacing with a system that requires inputs in the form value.
  12. Click OK. You return to the Entity tab of the Interface window.
Related topics
About Interfaces
Creating an Interface - Entity Tab - ASCII
Column Number