Date formats and currency codes
- DDMMYYYY (day, month, year)
- MMDDYYYY (month, day, year)
- YYYYMMDD (year, month, day)
Databases store dates in the sequence of YYYYMMDD, but then adjust the sequence of the day, month, and year elements according to the country. The separator can vary, for example, a period separates YYYY from MM and from DD in Hungary.
Currency codes must use the ISO 4217 standard, which defines three alpha currency designators. The first two letters of the code are the ISO 3166-1 alpha-2 country codes, for example, US (United States), with the third letter the initial of the currency, D (dollar). There is also a three-digit code number assigned to each currency. For example, 840 is the numeric code for the US dollar.
How Infor meets this requirement
The ISO 4217 currency codes are available on the ISO Currency Codes form. Use the codes and descriptions in this list to create or map to your currency codes on the Currency Codes form.
The date format used generally depends on the localization settings for the application.
The default date and number formats for reports are overridden by the Windows regional settings on the computer where the application client is installed. To override the default or regional settings for report output, set the date format and numeric format for a specific language on the Language IDs form. Then select that language in the User Preferences form. However, some reports are set up, in the editor for the report generator, to prevent certain dates or numbers from being reformatted.