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
TM1 Web 952 Date Issue
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: TM1 Web 952 Date Issue
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.
-
- Posts: 16
- Joined: Mon Nov 28, 2011 11:58 am
- OLAP Product: TM1
- Version: TM1 9.4 and 9.5.2
- Excel Version: Excel 2003
Re: TM1 Web 952 Date Issue
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
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
-
- Regular Participant
- Posts: 180
- Joined: Thu Jul 01, 2010 3:06 am
- OLAP Product: Cognos Express
- Version: 9.5
- Excel Version: 2007
- Location: Melbourne, Australia
Re: TM1 Web 952 Date Issue
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.