Skip to main content

Time

1. Field Introduction

This control does not display the date, only records the time.

2. Display Format

Supports two formats:

  • Hour:Minute, for example: 08:10
  • Hour:Minute:Second, for example: 08:10:10

3. Default Value

3.1 Supports Fixed Value​

Manually select a time, or enter a time in the correct format.

3.2 Supports Current Time (Coming Soon)​

Uses the system's current time.

3.3 Supports Dynamic Value​

3.3.1 Other Field Values​

(1) Current record, matching time field type Supports: Date, Time, Formula (formula date calculation is date plus or minus time)

(2) Related records, matching date field type Supports: Date, Time, Formula (formula date calculation is date plus or minus time), Creation Time, Last Modified Time

*The default value of the time field can be set to a date type; However, the default value of the date field cannot be set to a time field, because the time field does not record the date (year-month-day).

3.3.2 Query Worksheet​

(1) Display field as time field, filter conditions:

  • Is, Is Not
  • Greater Than, Less Than
  • Greater Than or Equal To, Less Than or Equal To
  • Within Range, Not Within Range
  • Is Empty, Is Not Empty

(2) Query worksheet, query time field condition dynamic value: Supports: Time, Date, Formula (formula date calculation is date plus or minus time), Summary, Fields from Other Tables

(3) After querying the record, fill in the value, matching time field type Supports: Date, Time, Formula (formula date calculation is date plus or minus time), Creation Time, Last Modified Time

4. Validation

Supports field content [Required].

5. Start Time, End Time

After setting the start time or end time, when selecting the time field value in the record, it can only be selected within the range.

6. Display Result of Time

  • If the value of minutes or seconds exceeds 59, it is written in the 60-base time system. For example, 05:65, the result is: 06:05.
  • If the value of hours exceeds 23, it is written in the 24-hour system. For example, 24:15:30, the result is: 00:15:30; or 25:25:25, the result is 01:25:25.

Examples:

Input ContentDisplay Result
5:605:06
17:44:6517:45:05
12:6013:00
19:65:5920:05:59
24:00:0000:00:00
28:45:6004:46:00

7. Supports Time Interval Filtering

  • The form needs to add a [Time] field.
  • Through clicking [Configure View] - [Quick Filter] - [Time], and then returning to the worksheet page, records can be filtered by time.