← Back to Date functions

Date.AddQuarters

This function will generate a new date, datetime, or datetimezone by adding a specified number of quarters to the input datetime value. The input parameters include the original datetime value (dateTi...

Syntax

Date.AddQuarters(dateTime as any, numberOfQuarters as number) as any

About

This function will generate a new date, datetime, or datetimezone by adding a specified number of quarters to the input datetime value. The input parameters include the original datetime value (dateTime) and the number of quarters (numberOfQuarters) to add.

Explanation

Increase the date, datetime, or datetimezone value by 1 quarter from the original date of 5/14/2011. To do this in Power Query, use the MDate.AddQuarters function with the input date #date(2011, 5, 14) and specifying to add 1 quarter. The output will be #date(2011, 8, 14).