TM1 Forum

Hi,

We have a report which when opened using perspectives displays the date format correctly

Example:
Date: 06/16/2012 ---> In excel the cell is formatted in Category Date and Type *3/14/2001 and the data is hardcoded.
Time: 08:00 ---> In excel the cell is formatted in Category Custom and Type hh:mm and the data is hardcoded.

When we open the report using TM1 Web, the report gets opened correctly sometimes (very less possibility) and most of the times the date and time is displayed as

Date: 2012-06-16T00:00:00.000
Time: 1899-12-31T08:00:00.000

Our Inference
TM1 Web does not change the value but it appends the time when only date is displayed and vice versa.

2012-06-16 T 00:00:00.000
Date which is hardcoded Unknown character "T" Timestamp

1899-12-31 T 08:00:00.000
Date Field Unknown character "T" Timestamp which is hardcoded


Steps we did
We changed the cell format to string and tried again, but we are getting the same data displayed in TM1 web.

Any help will be greatly appreciated.

Thank you,
Vinoth

Have you tried putting " ' " before the date ? Sometimes using the excel convert format doesnt really work. But putting a single quote before the date can be for sure that it is a string instead of a date.

Hi Winsonlee,

Thanks a ton for your response. The workaround you provided worked like a charm
Do you have any idea about the reason that would have caused this issue in TM1 web server?

Thanks,
Vinoth

I have exactly the same issue as you have a while ago. When excel is converted to tm1web there might be certain things that cant be recognized by the code that does the conversion. I just try an error to find out the answer.