Skip to main content

date

1. Field introduction

Field for recording dates and datetimes.

2. Display format

Two formats supported: date and datetime

3 date types: Year, for example: 2023 Year-month, for example: 2023-01 Year-month-day, for example: 2023-01-01

3 datetime types: Year-month-day, for example: 2023-01-01 08 Year-month-day hour:minute, for example: 2023-01-01 08:00 Year-month-day hour:minute:second, for example: 2023-01-01 08:00:00

3.Default value

3.1 Support fixed value​

Manually select a date and time.

3.2 Support current date​

The current date at the time of operation. After setting, the current date of the system will be automatically filled in every time a new record is added.

3.3 Support dynamic values​

3.3.1 Other field values​

(1) Current record, matching fields of date type Support: date field, formula field (formula date is calculated as date plus or minus time, and the output format matches the date field type)

(2) Associated records, adapt to the field type of the date field Supports: date field, formula field (formula date is calculated as date plus or minus time, the output format matches the date field type), creation time, last modification time

3.3.2 Query worksheet​

(1) Query the worksheet, the query condition field is the date field, and the filtering conditions are: Yes, not, greater than, less than, greater than or equal to, less than or equal to, within the range, not within the range, empty, not empty

(2) Query the worksheet, the query condition field is the date field, A. When the conditions are yes, no, greater than, less than, greater than or equal to, less than or equal to , the conditional dynamic value of the matching date field supports: Date, formula (formula date is calculated as date plus or minus time, and the output format matches the date field type)

B. When the conditions are yes, no, greater than, less than, greater than or equal to, less than or equal to , the fixed value of the condition is supported:

  • Today, yesterday, tomorrow, this week, last week, this month, last month, this year, last year, one week ago, one week later, one month ago, one month later
  • A specific number of days before, a specific number of days after, a specific number of days before today, a specific number of days after today: Enter a fixed number
  • Exact date: enter a fixed date

C. When the condition is within the range or not within the range, it is supported to set two fixed value dates and filter the query based on the range value between the two dates.

(3) After querying the record, you can fill in the field type of the current date field. Supports: date field, formula field (formula date is calculated as date plus or minus time, the output format matches the date field type), creation time, last modification time

3.3.3 Function calculation​

The date function is applicable. The function calculation result is the date and date time value which can be used as the default value.

4. Verification

Support field content [required] Support field content [no duplication allowed]

5.Start date, end date

The date field supports setting the start date and end date. The start date is the earliest date that can be selected when the date field is selected, and the end date is the latest date that can be selected.

For example, the starting date of the delivery date is set to the dynamic value "order date", and the order date value is 2023-10-23 Then, when selecting the delivery date, the date picker can only start to be selected from 2023-10-23.