SOYEAR

The SOYEAR function takes the date as input and returns the year's starting date. Node references and measures are also accepted as input arguments. Use DATE.SET() to set the format of the output date.

Syntax

SOYEAR(date)

Arguments

date - The date which is passed as an input to the function. Required.

Return value

Date representing the start of the year.

Example

SOYEAR("05/29/2024")
//Returns 1/1/2024

Last updated

Change request #480: Date Formulas