> ## Documentation Index
> Fetch the complete documentation index at: https://help.dingtalk.io/llms.txt
> Use this file to discover all available pages before exploring further.

# DATEDELTA

> The DATEDELTA function calculates a date after adding or subtracting a specified number of days. It is supported in various YiDA scenarios, such as forms, workflow design, and integration & automation. Enter a date and the number of days to adjust to return the new date in timestamp format.

The **DATEDELTA** function calculates a date after adding or subtracting a specified number of days.

## Supported Scenarios

The DATEDELTA 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

## Syntax

```text theme={"theme":{"light":"github-light","dark":"github-dark"}}
DATEDELTA(date,delta_days)
```

## Attributes

| **Attribute** | **Required** | **Description**                                                                                     |
| ------------- | ------------ | --------------------------------------------------------------------------------------------------- |
| date          | Yes          | The date object.                                                                                    |
| delta\_days   | Yes          | The number of days to add. Use a positive number to add days or a negative number to subtract days. |

## Return Value

| **Return type** | **Description**                                                                         |
| --------------- | --------------------------------------------------------------------------------------- |
| Number          | The date after adding or subtracting the specified number of days, in timestamp format. |

## Example

As shown below, use the `DATEDELTA()` function to calculate the date 100 days from now and assign it to a date component.

## Try It Out

Add or subtract a specified number of days from a given date.