Thread: Calendar Table

I have a Calendar table that need to be displaying Fiscal Start and End Date as in below:

The Calendar is currently have data for years 2023 - 2028:

-- Query to get the year and number of days
SELECT 
    EXTRACT(YEAR FROM "Date") AS "Year", 
    COUNT(*) AS "NumberOfDays"
FROM "Prod"."IMETA_Calendar"
GROUP BY EXTRACT(YEAR FROM "Date")
ORDER BY EXTRACT(YEAR FROM "Date");

--

When i run code:

-- Query to get the year and number of days
SELECT
    EXTRACT(YEAR FROM "Date") AS "Year",
    COUNT(*) AS "NumberOfDays"
FROM "Prod"."IMETA_Calendar"
GROUP BY EXTRACT(YEAR FROM "Date")
ORDER BY EXTRACT(YEAR FROM "Date");

-- Table creation script
CREATE TABLE "Prod"."IMETA_Calendar" (
    "Date" timestamp NOT NULL,
    "FY" varchar(255),
    "Period" varchar(255),
    "Quarter" varchar(255),
    "Day" int NOT NULL,
    "Month" int NOT NULL,
    "Year" int NOT NULL,
    "Loaddate" timestamp NOT NULL
);

I get some output: 

For any other Period and Year i get no results. What is wrong with my Calendar table. Attached is the Calendar Table Data.

CREATE TABLE [Prod].[IMETA_Calendar](

[Date] [datetime] NOT NULL,

[FY] [nvarchar](255) NULL,

[Period] [nvarchar](255) NULL,

[Quarter] [nvarchar](255) NULL,

[Day] [int] NOT NULL,

[Month] [int] NOT NULL,

[Year] [int] NOT NULL,

[Loaddate] [datetime] NOT NULL

) ON [PRIMARY]