SOMONTH

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

Syntax

SOMONTH(date)

Arguments

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

Return value

Date representing the start of the month.

Example

SOMONTH("05/29/2024")
//Returns 1/5/2024

Last updated