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.
Filter open Opportunities to FISCAL_YEAR(CloseDate) = 2027 and FISCAL_QUARTER(CloseDate) = 1.
Only the challenge's base org data.
8 row(s), any order
| # | Id | Name | Amount | CloseDate |
|---|---|---|---|---|
| 1 | 006000000000001AAA | Fiscal Boundary Deal 1 | 1000 | 2027-02-15 |
| 2 | 006000000000002AAA | Fiscal Boundary Deal 2 | 2000 | 2027-02-15 |
| 3 | 006000000000003AAA | Fiscal Boundary Deal 3 | 3000 | 2027-02-15 |
| 4 | 006000000000004AAA | Fiscal Boundary Deal 4 | 4000 | 2027-02-15 |
| 5 | 006000000000005AAA | Fiscal Boundary Deal 5 | 5000 | 2027-02-15 |
| 6 | 006000000000006AAA | Fiscal Boundary Deal 6 | 6000 | 2027-02-15 |
| 7 | 006000000000007AAA | Fiscal Boundary Deal 7 | 7000 | 2027-02-15 |
| 8 | 006000000000008AAA | Fiscal Boundary Deal 8 | 8000 | 2027-02-15 |