# Forecast Deals Across the Fiscal-Year Boundary

**Type:** SOQL · **Difficulty:** Hard · **Topics:** SOQL, Fiscal Calendar, Date Functions, Opportunity

Practice this problem interactively (write and run your SOQL against realistic data): https://www.forcechallenges.com/problems/forecast-deals-across-fiscal-year-boundary-v3

## Problem

With a January fiscal-year start and a report run in October 2026, the next fiscal quarter is Q1 FY2027. Return open Opportunities closing in that period with Id, Name, Amount, and CloseDate. Use fiscal-year and fiscal-quarter functions so the query follows the organization's fiscal calendar rather than relying on calendar-quarter dates.

## Constraints

Filter open Opportunities to FISCAL_YEAR(CloseDate) = 2027 and FISCAL_QUARTER(CloseDate) = 1.

---
Source: ForceChallenges · last updated 2026-10-17