Table of contents
Collapse the table of content
Expand the table of content


Owen Duncan|Last Updated: 10/5/2018
1 Contributor

Date.IsInPreviousNQuarters(dateTime as any, quarters as number) as nullable logical


Indicates whether the given datetime value dateTime occurs during the previous number of quarters, as determined by the current date and time on the system.

  • dateTime: A date, datetime, or datetimezone value to be evaluated.
  • quarters: The number of quarters.

Example 1

Determine if the quarter before the current system time is in the previous two quarters.

Date.IsInPreviousNQuarters(Date.AddQuarters(DateTime.FixedLocalNow(), -1), 2)


© 2018 Microsoft