StartOfMonth

Summary

The StartOfMonth function returns the first day and time value for the given month.

Syntax

StartOfMonth([date|date_time|instant|offset_date_time|zoned_date_time])

Return Type

Offset_date_time

Details

The function accepts an optional date or date time input parameter. The function returns the first offset_date_time value for the given month and year found in the input parameter value. If no input parameter is provided, Connect uses the current local date (Pacific Time).

Examples

eval StartOfMonth();

screen-shot-2016-09-09-at-1-27-51-pm

 

eval StartOfMonth(‘1977-04-22’);

screen-shot-2016-09-09-at-1-27-56-pm

 

Related Functions

EndOfMonth

EndOfYear

StartOfYear