CIC Data Formatting Options in Costpoint and Windows®
For many companies using Costpoint, the dates, times, numbers, and currency amounts are formatted in the standard format for the United States. These formats affect data entry, display of data on screens, and printing of data on reports.
To run Costpoint with the currencies of other countries, you must use the formats commonly used in those countries. If Costpoint's default settings (U.S. format as shown in Table 1) are satisfactory for your organization, you do not need to adjust the settings.
To accommodate other countries' formats, Costpoint supports many options for the formatting of dates, times, numbers, and currency. This table compares the formats used in the United States with those used in the Netherlands:
| United States | Netherlands | |
|---|---|---|
| Date Order | Month, Day, and Year | Day, Month, and Year |
| Date Separator | Slash (/) | Dash (-) |
| Examples: | 05/15/11 or 05/15/2011 | 15-05-11 or 15-05-2011 |
| Time Format | 12-hour | 24-hour |
| Time Separator | Colon (:) | Colon (:) |
| Examples: | 01:30:30 PM | 13:30:30 |
| Decimal Separator | Period | Comma |
| Thousands Separator | Comma | Period |
| Examples: | 1,234.56 | 1.234,56 |
| Currency Symbol | $ | E |
| Decimal Places | 2 | 2 |
| Positive Format | $123.22 | E 123,22 |
| Negative Format | -$123.22 or ($123.22) | 123,22 E- |
| Examples: | $1,234.56 | E 1.234,56\ |
| -$1,234.56 or ($1,234.56) | 1.234,56 E- | |
If you run Costpoint in the Netherlands (or in the currency of the Netherlands), you can set up Costpoint to display all date, time, number, and currency information using the formats appropriate for the Netherlands.
A Deltek Costpoint client in any country can specify any formats. Decide on the options you want, associate them with a currency, and select that currency as the functional currency for the database.