DAY

DAY takes a date and returns an integer representing the day of the month on which it falls. The structure of the date response returned follows the ISO 8601 standard.

Function category: Date

Syntax

DAY(arg1)

Arguments

Description

arg1

Date object or a function that resolves to a date object.

Example

Example 1: Find day of the month

Let's say we received a response with the following insurance claim information:

{
"data":{
"claim": {
"issue_number": "2a515",
"date": "NOW()"
}
}
}

If we wanted to find the day of the month for the date field, which is set to the value of NOW, we could use DAY:

DAY(data.claim.date)

This would return an integer with the day at the time of calling.