Specify a Date and Time Parameter

Use the Date Time Parameter dialog box to specify parameters for a "date/time" data type.

To specify a date and time parameter

1. Do one of the following:

• If the export file doesn't exist, do the steps to Create an Export File Layout Using a Stored Procedure.

• If the export file exists, click the [Export Layout Name] tab on the Export Files tab (for example, Standard Export).

2. In the Name box in the data grid, click the Edit icon for a DateTime data type. The Date Time Parameter dialog box appears.

Name: Descriptive name for the parameter.

Prompt: Message to display to the user to request input.

Format: Date and time format. For example, MMDDYYYY HH:MM:SS, where MM=month, DD=day, YYYY=year, HH=hour, MM=minute, and SS=second.

3. Complete the information and then click OK.

Related Topics

Create an Export File Layout Using a Stored Procedure

Export Files