| 1. | From the status page of the process for which to establish format options, click Set format options under Tasks. The Set format options screen appears. |
| 2. | On the Currency tab, specify how currency data should appear in the exported data. Enter the currency symbol, number of decimal places to use in currency data, digit grouping symbol, and decimal symbol. The Example section displays how currency data appears with the entered options. |
| 3. | Select the Date and Time tab. |
| 4. | Under Date format, Fuzzy date format, and Month/day format,select or enter how the various types of dates should appear in the exported data. The Example sections display how a date appears in the specified formats. |
Note: A “fuzzy date” is an incomplete date. For example, a fuzzy birth date of a constituent may include the month and year, but not the day.
|
Date Specifier |
Description |
Example |
|
d |
Numerical day of the month, single-digit |
4 |
|
dd |
Numerical day of the month, double-digit |
04 |
|
ddd |
Abbreviated day name |
Tue |
|
dddd |
Full day name |
Tuesday |
|
M |
Numerical month, single-digit |
7 |
|
MM |
Numerical month, double-digit |
07 |
|
MMM |
Abbreviated month name |
Jul |
|
MMMM |
Full month name |
July |
|
yy |
Year, two-digits |
80 |
|
yyyy |
Year, four-digits |
1980 |
| 5. | Under Hour/minute format, select how times should appear in the exported data. The Example section displays how a time appears in the specified format. |
Note: You cannot include seconds or timezone offsets in the format of the exported time data.
|
Date Specifier |
Description |
Example |
|
hh |
Hour, two-digits, in a 12-hour cycle |
11 |
|
HH |
Hour, two-digits, in a 24-hour cycle |
23 |
|
mm |
Minute, two-digits, 00 to 59 |
17 |
|
tt |
Ante meridiem (AM) or post meridiem (PM) |
PM |
| 6. | On the Export tab, select the Line break character for the data exports. |
| 7. | Click Save. You return to the process status page. |