Power Query
Search…
Date.StartOfQuarter

Date.StartOfQuarter

Returns the first value of the quarter.
function (optional dateTime as nullable any) as nullable any

Description

Returns the first value of the quarter dateTime. dateTime must be a date, datetime, or datetimezone value.

Category

Date

Examples

Find the start of the quarter for October 10th, 2011, 8:00AM (#datetime(2011, 10, 10, 8, 0, 0)).
Date.StartOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))

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

Copy link
On this page
Date.StartOfQuarter
Description
Category
Examples