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()arrow-up-right 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
SOMONTH

Was this helpful?