Date and Time Functions

This article lists all date and time functions in YiDA, along with the issues you may encounter when using them.

Function Overview

Function	Description
CASCADEDATEINTERVAL	Calculates the number of days between the start and end dates in a date range picker component.
CASCADEDATEINTERVALV2	Returns the number of days between two dates in a date range.
DATE	Converts a timestamp into a date object.
DATEDELTA	Adds or subtracts a specified number of days to or from a given date.
DAY	Returns the day of the month of a date.
DAYBEGIN	Returns the timestamp of a specified date component with hours, minutes, and seconds set to zero.
DAYEND	Returns the timestamp of a specified date component with hours, minutes, and seconds set to their maximum values.
DAYS	Returns the number of days between two dates.
DAYS360	Returns the number of days between two dates based on a 360-day year.
HOUR	Returns the hour of a date.
ISOWEEKNUM	Returns the week number of a specified date within the year.
MINUTE	Returns the minute of a date.
MONTH	Returns the month of a date.
NETWORKDAYS	Calculates the number of working days between two specific dates.
NOW	Returns the current time. Equivalent to the TODAY function.
SECOND	Returns the second of a date.
SYSTIME	Returns the current server time.
TIME	Returns the decimal number for a specific time.
TIMESTAMP	Converts a date object into a timestamp. It is mainly used to convert a date object produced by a date formula into a timestamp and assign the value to a date component.
TODAY	Returns today’s date.
WEEKNUM	Returns the week number of a specific date.
WORKDAY	Calculates the date that falls N working days after a specific date. Weekends are excluded from working days by default, and you can define holidays to specify working days more precisely.
YEAR	Returns the year of a date.
YEARBEGIN	Returns the first date of the year in which a date falls.
YEAREND	Returns the last date of the year in which a date falls.

Basic Concepts

The date component returns a timestamp in milliseconds. The following two basic concepts relate to date functions:

Timestamp: A timestamp is a format that computers use to record time. It is usually a character sequence that uniquely identifies a moment in time. In YiDA forms, the date component stores time as such a sequence.
Date object: A date object represents the year, month, day, hour, minute, and second. Its format is Sat Aug 01 2015 00:00:00 GMT+0800 (China Standard Time), which corresponds to 00:00:00 on August 1, 2015, Beijing time. Date objects support various operations, such as date addition and subtraction.

In YiDA, letters are commonly used to represent date formats. The following table lists the meaning of each letter.

Letter	Meaning
G	Era designator
y	Year
M	Month
d	Day
h	Hour in AM/PM (1–12)
H	Hour in day (0–23)
m	Minute
s	Second
S	Millisecond
E	Day of week
D	Day of year
F	Day of week in month
w	Week of year
W	Week of month
a	AM/PM marker
k	Hour in day (1–24)
K	Hour in AM/PM (0–11)
z	Time Zone

For example, use the pattern string yyyy-MM-dd HH:mm:ss:S E D F w W z to format the current time as the Default of the Formatted Date text component. Define the formula as follows: The page displays as follows:

FAQ

Q1: How do I use a formula to get the current date?

A: Open the form designer page. The page already contains a date component. Select it, choose Formula Edit from the Default drop-down list on the right, and then click the blue Edit Formula button below. Click to build the complete formula: TIMESTAMP(NOW()). Click Confirm, and then click Save in the upper-right corner of the page designer.

Q: How do I automatically get the contract end date? A: Follow these steps to configure the contract end date.

Add two date components to the form and name them Start Date and End Date.
Add two Numerical components and name them Contract Term and Leap Year Adjustment.

Step 1

Because leap years and common years differ, contract duration is usually calculated based on a common year (365 days). Handle this with a formula in advance. To keep the form clean, hide this field and set its data to Always submit. The detailed formula configuration is shown below:

After you enter the contract start time and contract term, the contract end time is calculated automatically. Configure the formula as follows

DATEDELTA(DATE(DATEDELTA(DATE(Start Date),365*Contract Term)),-1+Leap Year Adjustment)

Result

Getting Started

Quick Start

Form Management

Workflow Design

Report Design

Aggregate Table Design

Portal Design

Custom Pages

Integration & Automation

Cool App

App Management

Platform Management

Internationalization

YiDA Dedicated

Developer Features

Function Overview

Basic Concepts

FAQ

​Function Overview

​Basic Concepts

​FAQ

Function Overview

Basic Concepts

FAQ