Date Settings
When importing files into Working Papers, it is important to specify the date formats used to avoid problems and inconsistencies. Once the date settings are set, Working Papers knows what to expect in the ASCII or Excel file being imported. The more information Working Papers has available, the more likely the import will be handled smoothly.
Specify the Date Settings
To specify date settings in the ASCII text file or Excel file you are importing, set the date in the Field Details screen by defining the column as Date. The options for the date format will appear in the bottom of the dialog.
| Field | Description |
|---|---|
| Date Format |
Select the format used for the date.
|
| Preview | The date is displayed according to the format chosen. If the date format is incorrect, select another format. |
Note: Microsoft Excel contains other date formats that are not supported. Use a date format specified in the table above to ensure your data is imported accurately.
