Hi,
I am struggling with time and date formats in TM1web. I have a worksheet with time column. I want to input time as format of h:nn (for example 9:30). This works fine in Perspectives but not in TM1web: if I enter 9:30 in cell,the following message is displayed: "Not a number: 9:30 Please use "," as decimal separator and " " as thousand separator (# ###,##)".
Can somebody give any advise how to solve this?
BR
Mikko
TM1web: date and time formats
-
lotsaram
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: TM1web: date and time formats
TM1 Web support for date and time formats using the TEXT() function and cell number formatting is "incomplete" at best and this can be further compounded and complicated by regional settings on the web server.
It would be helpful if you could provide details of the regional settings for date, time and number formatting on the TM1 server, web server and Excel client.
Also is the field only for display purposes or is it required to be a string DBRW reference or a number formatted DBRW reference? If it is a string value for display then you should be able to get the result you need by either pre-formatting the string value or by using the MID() function. If its the later and you are holding dates as a numeric value then the problem is more difficult to solve ...
It would be helpful if you could provide details of the regional settings for date, time and number formatting on the TM1 server, web server and Excel client.
Also is the field only for display purposes or is it required to be a string DBRW reference or a number formatted DBRW reference? If it is a string value for display then you should be able to get the result you need by either pre-formatting the string value or by using the MID() function. If its the later and you are holding dates as a numeric value then the problem is more difficult to solve ...