> For the complete documentation index, see [llms.txt](https://docs.adapptio.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.adapptio.com/reference-guide/functions/date.md).

# Date

### Date Format

*Format date with a custom format.*

#### Expression:

**DATE\_FORMAT**(*date*: string, *format*: string)

#### Return:

*formatedString*: string

#### Example of usage:

```javascript
DATE_FORMAT("2022-05-09", "dd. MM. yyyy")
DATE_FORMAT("2022-05-09", "d. MM. yy")

Return value:
"09. 05. 2022"
"9. 05. 22"
```

### Current Date

*Returns the current date as ISO-8601 string.*

#### Expression:

**DATE\_NOW**()

#### Return:

*ISO-8601 date string*: string

#### Example of usage:

```javascript
DATE_NOW()

Return value:
"2022-05-20" // current date
```

### Date Difference

*Returns a difference between two dates in the required time or date format.*

#### Expression:

**DATE\_DIFF**(*date1*: string, *date2*: string,  format?: string = "`seconds`")

*format\_types =* (`years`, `months`, `days`, `hours`, `minutes`, `seconds`)  || `seconds`

#### Return:

{*format\_types*: float}

#### Example of usage:

```javascript
DATE_DIFF("2022-05-17", "2021-04-15", "minutes")

Return value:
{"minutes":571680} 
```