| Id: | 11694 |
| Product: | finPOWER Connect |
| Type: | NEW |
| Version: | 2.00.03 |
| Opened: | 27/01/2014 |
| Closed: | 12/02/2014 |
| Released: | 04/03/2014 |
| Job: | J012788 |
 Breaking Change |
|
Regional Settings; date entry is incorrectly handled for non day-month-year regions, e.g. USA
There are various issues with date and date range entry for non day-month-year regions, e.g. USA where date entry is month-day-year. For example, the date spin control might change the incorrect part of the date.
Within finPOWER Connect the computer's Regional Settings are largely ignored, instead the User Preferences date formats are used for data entry and display.
When opening a database two additional warnings are shown:
1. The date formats specified under User Preferences, Formatting are inconsistent with the Computer's Region and Language Settings.
2. The date formats specified under User Preferences, Formatting are inconsistent. For example, one is d-m-y and another m-d-y.
In addition, some functions in the Business Layer may react differently than in previous versions. For example, the dayMonthYearOrder parameter passed to functions like ConvertToDate in finBL.Runtime.DateUtilties must be correctly formatted for dates. This parameter accepts "DMY", "MDY" or "YMD" and in addition correctly formatted dates strings, where d=Day, M=Month and y=Year , for example "yyyy-MM-dd".