DAY | Anapedia - Anaplan Technical Documentation

English

The DAY function returns the day from a date as a number between 1 and 31. If the day is blank, it returns 0.

For example, you can use the DAY function to extract the day of an employee's start or end date.

DAY(Date)

Arguments

Argument	Data type	Description
Date	Date	The date to extract the day from.

The DAY function returns a numeric result.

DAY(DATE(2018, 1, 4))

In this example, the formula returns the number 4.

In this example, the date line items Contractor start date and Contractor end date contain start and end dates for different contractors.

The DAY(Contractor end date) formula returns the day of the date from Contractor end date.

	James Smith	Simon Peters
Contractor start date	08/31/2019	09/22/2019
Contractor end date `ADDMONTHS(Contractor start date, 6)`	02/29/2020	03/20/2020
Contractor end day `DAY(Contractor end date)`	29	20

Disclaimer

We update Anapedia content regularly to provide the most up-to-date instructions.