Date.StartOfMonth

Returns the start of the month.

Syntax

Date.StartOfMonth(
    dateTime as any
) as any

Remarks

Returns the start of the month that contains dateTime. dateTime must be a date or datetime value.

Examples

Example #1

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

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

Result:

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

Category

Date