← Back to Date functions

Date.StartOfMonth

This function retrieves the beginning of the month in which the specified dateTime falls. The input dateTime should be either a date or datetime type value.

Syntax

Date.StartOfMonth(dateTime as any) as any

About

This function retrieves the beginning of the month in which the specified dateTime falls. The input dateTime should be either a date or datetime type value.

Explanation

To determine the start of the month for October 10th, 2011 at 8:10:32 AM, the Power Query MDate function "StartOfMonth" is utilized with the specific date and time input. The output generated is October 1st, 2011 at 12:00:00 AM.