Date.EndOfQuarter
Date.EndOfQuarter(dateTime as any) as any
Returns the end of the quarter that contains dateTime
. Time zone information is preserved.
dateTime
: Adate
,datetime
, ordatetimezone
value from which the end of the quarter is calculated.
Find the end of the quarter for October 10th, 2011, 8:00AM.
Usage
Date.EndOfQuarter(#datetime(2011, 10, 10, 8, 0, 0))
Output
#datetime(2011, 12, 31, 23, 59, 59.9999999)