What are the formats for defining export data types?
For number formats, you use a number sign (#) for each digit, and a zero after the decimal point for each decimal place.
For date formats, use dd, m (or mm, mmm), yy (or yyyy) and a separator to build a format string.
Example:
The values for these data types would be displayed as follows:
- daNumberType – 12345
- commaNum – 12345.00
- daDateType – 02/14/18
- anothertype – Feb-14-2018
Tip: When you select an export data type as you are creating an export definition, the Format definition list displays a preview. For example, the following screen shot displays the two date types.