What is the value range for time format "hh:mm" in TIBCO Statistica?
Article ID: KB0075354
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistica | 13.3.1 and later |
Description
What is the value range for time format "hh:mm" in Statistica? Will it go over 24:00 hrs?
Issue/Introduction
What is the value range for time format "hh:mm" in TIBCO Statistica?
Environment
Windows
Resolution
If the user has set the variable data type to be "Time" with format "hh::mm", the time format hh:mm in Statistica application will only go from "00:00" till "23:59".
Example: In Statistica Web Data Entry setup, if you set a label of "Date/Time" type with format "hh:mm", in the web data entry form, you will get error message when user is entering values from 24:00 and above (e.g. 25:14).
Error appears when entering time value e.g. 25:14.
Error appears when entering time value e.g. 24:00.
The Time label will accept values between 00:00 to 23:59.
For another example, in Statistica Spreadsheet, a Time variable with format "hh:mm" will only display values from 00:00 to 23:59.
When user manually enters an out-of-bound value to the Time variable in the spreadsheet, for example, 25:56, it will automatically converted to 1:56. Similarly, 27:34 will be automatically converted to 3:34 as shown in above figure.
Example: In Statistica Web Data Entry setup, if you set a label of "Date/Time" type with format "hh:mm", in the web data entry form, you will get error message when user is entering values from 24:00 and above (e.g. 25:14).
Error appears when entering time value e.g. 25:14.
Error appears when entering time value e.g. 24:00.
The Time label will accept values between 00:00 to 23:59.
For another example, in Statistica Spreadsheet, a Time variable with format "hh:mm" will only display values from 00:00 to 23:59.
When user manually enters an out-of-bound value to the Time variable in the spreadsheet, for example, 25:56, it will automatically converted to 1:56. Similarly, 27:34 will be automatically converted to 3:34 as shown in above figure.
Feedback
Yes
No
Powered by
