← Back to Date functions

Date.EndOfQuarter

The function retrieves the last day of the quarter that includes the dateTime provided. The time zone data is maintained. The input parameter, dateTime, should be a date, datetime, or datetimezone val...

Syntax

Date.EndOfQuarter(dateTime as any) as any

About

The function retrieves the last day of the quarter that includes the dateTime provided. The time zone data is maintained. The input parameter, dateTime, should be a date, datetime, or datetimezone value used to calculate the end of the quarter.

Explanation

Determine the closing date of the quarter for October 10, 2011, at 8:00 AM using the Power Query MDate function. The result will be December 31, 2011, at 11:59:59.9999999 PM.