Date.StartOfQuarter
Syntax
Date.StartOfQuarter(dateTime as any) as any
About
Returns the start of the quarter that contains dateTime
. dateTime
must be a date
, datetime
, or datetimezone
value.
Example 1
Find the start of the quarter for October 10th, 2011, 8:00AM.
Usage
Date.StartOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))
Output
#datetime(2011, 10, 1, 0, 0, 0)