The SOMONTH function returns the start date of the month for a given date. References and measures are also accepted as arguments. This function is commonly used to identify monthly reporting periods and perform month-based calculations.
Syntax
SOMONTH(date)
Arguments
date: The input date.
Return value
Returns the start date of the month.
Example
SOMONTH("05/29/2026")
Returns 5/1/2026, which is the start date of the month containing 05/29/2026.
