Delete Cell with Date

[Willi]

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

[declanr]

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;-;-

[Willi]

Thx for the suggestion. But no change.

[jim wood]

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.

[Willi]

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