TM1 Date Error it shows 12/31/99

[akn]

Hello All,
When the user put date in Termination date field it works as expected at all 3 places web, active form and cube. 2 behaviors are seen while deleting the termination date.
1) When user tries to delete the termination date TM1 puts 12/31/99 at all 3 places web, active form and cube.
2) When user double clicks the cell the cursor selects the complete data and then delete it TM1 cell becomes blank at all 3 places in web, active form and cube.

What client needs is just by one click - delete key the termination date should get wiped out and 12/31/99 should not appear or store the value in any place.

Attached is the file for more clarification.

Thanks,
Aashish

[tomok]

is your date element string or numeric? If it is numeric then your issue is due to date formatting of the cell. To keep 0 from showing up as 12/31/99 then you need to modify the date formatting to show something different than 12/31/99 when the value is zero.

[akn]

Hi,

The format of date element in cube is Numeric- C:mm/yy/dd

[akn]

Hi Tom,

Now if I change the Element from numeric to string it works as expected. but one more on that if I change the property from numeric to string will all the rules and ti need to be changed.

Thanks,
Aashish

[declanr]

You are better off leaving it as numeric but updating the custom format to accommodate blanks.
It uses standard excel format where you put the format for positive then negative and then blank separated by semicolons
e.g. mm/yy/dd;-;-

[cdredmond]

Assuming you are using the Delete key, have you tried right-click and then choose Delete?

[akn]

Hi cdredmond,

I tried with double clicking the cell which selects the complete date and then hit the delete button which works as expected. But the client needs it to be like other cells where they keep the cursor on the cell and hit delete without double clicking the cell.

Thanks,
Aashish

[akn]

Hi Declan,

Using mm/dd/yy:-:- dosent help as it brings the cells as - in the cube dosent appear in the active form.

Thanks,
Aashish