DAYS360

The DAYS360 function calculates the number of days between two dates based on a 360-day year (12 months of 30 days each). DAYS360 calculates the result by counting the number of full months between the two dates, multiplying by 30, and then adding the remaining days of the start and end months as needed.

Supported Product Scenarios

The DAYS360 function is supported in the following YiDA scenarios.

Form (main table fields)
Form (business association rules)
Form (validation)
Workflow design (validation rules)
Workflow design (association actions)
Integration & automation
Workflow node
Connector

Format

DAYS360(end_date,start_date,method)

Attribute Description

Attribute	Required	Description
end_date	Yes	The date object of the end time.
start_date	Yes	The date object of the start time.
method	No	Specifies how to handle cases where the start date and end date fall in the same month. Values: • true: Uses the European method for calculation. • false: Uses the U.S. (NASD) method for calculation. If left blank, the default is false. Note: For example, when calculating the difference between 2023-01-01 and 2023-12-31, the U.S. method returns 360, while the European method returns 359.

Return Value

Return value type	Description
Number	The number of days between the specified dates.

Example

As shown below, use the DAYS360() function to get the number of days between two dates.

European method
U.S. method

Try It

Returns the number of days between two dates.

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

Supported Product Scenarios

Format

Attribute Description

Return Value

Example

Try It

​Supported Product Scenarios

​Format

​Attribute Description

​Return Value

​Example

​Try It

Supported Product Scenarios

Format

Attribute Description

Return Value

Example

Try It