DATE
Use the DATE function to create a date from year, month, and day values, which can be literals, fields, or formulas that return Number values.
Use
DATE( year, month, day )
Create a date from the year, month and day.
| Parameter | Required | Description |
|---|---|---|
| year | Yes | the value of the year |
| month | Yes | the value of the month from 1 to 12 |
| day | Yes | the value of the day of the month from 1 to 31 |
| Returns | Date |
Use with literals
DATE(2024, 1, 31)
returns 31/01/2024
Use with fields
DATE(YEAR(@CompleteDetails.out.DOB), 1, 1)
if field @CompleteDetails.out.DOB is 27/02/1996, returns 01/01/1996
ON THIS PAGE