Date.StartOfMonth

Syntax

Date.StartOfMonth(dateTime as any) as any

About

Returns the first value of the month given a date or datetime type.

Example 1

Find the start of the month for October 10th, 2011, 8:10:32AM (#datetime(2011, 10, 10, 8, 10, 32)).

Date.StartOfMonth(#datetime(2011, 10, 10, 8, 10, 32))

#datetime(2011, 10, 1, 0, 0, 0)