Date format is set up using the Date Format dialog box and determines parameters of analysis of the date used in data provider.
NOTE. Date format is set up if calendar elements are arranged in data provider columns.
To open the dialog box, click the Set Up button on the Data Binding page in the data import wizard.
To form date format, use the Date Format box. The format can contain:
Any characters entered from the keyboard
Substitutions from the Allowed Substitutions list. To insert the selected substitution:
Click the Insert button.
Double click the substitution.
The substitution will be inserted into the end of the date format.
The created date format is displayed in the Example box.
The following combinations in the template are not allowed:
Quarter and month
Half-year and month
Half-year and quarter
Half-year and week
Week and day
Quarter and week
Month and week.
See also: