What is the value range for time format "hh:mm" in TIBCO Statistica?

What is the value range for time format "hh:mm" in TIBCO Statistica?

book

Article ID: KB0075354

calendar_today

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).

User-added image
Error appears when entering time value e.g. 25:14.
User-added image
Error appears when entering time value e.g. 24:00.
User-added image
The Time label will accept values between 00:00 to 23:59.
User-added image


For another example, in Statistica Spreadsheet, a Time variable with format "hh:mm" will only display values from 00:00 to 23:59. 

User-added image
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.