Power Query
Search…
Date.AddQuarters

Date.AddQuarters

Adds the specified quarters to the date.
function (optional dateTime as nullable any, numberOfQuarters as number) as nullable any

Description

Returns the date, datetime, or datetimezone result from adding numberOfQuarters quarters to the datetime value dateTime.

Category

Date

Examples

Add 1 quarter to the date, datetime, or datetimezone value representing the date 5/14/2011.
Date.AddQuarters(#date(2011, 5, 14), 1)

date(2011, 8, 14)

Copy link
On this page
Date.AddQuarters
Description
Category
Examples