TM1 Forum

Hello,

first the environment: It's TM1 10.2.2 with FP 3 and FP 6. Both with same behaviour. A very simple model with a Cube with just 2 Dimensions:

- Number
- Measures

In Measures we have some Date-Fields decaled as numeric Elements.

In Excel they are formatted as dates. The normal display and entering is working like expected.

The problem comes when I work with this sheet in TM1Web. If i press DELETE I get the contents of "11.11.87108" in this cell and in the Cube this is represented as the number 31121899. If I press "Backspace" it works like expected that the date is "31.12.1899" with a number of 0 in the cube.

How can I define the cell that delete is here working like Backspace?

Thanks in advance and best regards,
Willi

Thats an interesting one.
The delete button works fine for me in similar situations but I have the actual measure in TM1 formatted as a date - try that and see if it helps.

E.g. C:dd-mm-yyyy;-;-

Thx for the suggestion. But no change.

Have you tried formatting the cells within the dimension attributes? I know it's moving away from why your getting the issue but it may help. Where I am at the moment has the same setup (on 10.1.1 granted) and we've never seen this but we have the dates formatted for the dimension as well,

Jim.

Thx, I think you mean the same as declanr. I tested this with no effect