Date Formats for Different Language Settings
In the Cube Viewer, when you enter a date in an n-level cell with no formatting, the date is converted to the Microsoft Excel Julian format. For example, 12/12/2009 displays as 2455178.
The date format used to identify an unformatted date depends on your language setting. The following table lists the format settings used in each supported language:
| Language | Date Format |
|---|---|
| Chinese |
yyyy-mm-dd |
| English |
mm/dd/yyyy |
| French |
dd/mm/yyyy |
| German |
dd/mm/yyyy |
| Italian |
dd/mm/yyyy |
| Japanese |
yyyy/mm/dd |
| Spanish |
dd/mm/yyyy |