I'm having difficulty with dealing with converting YYYYMMDD in a SQL Server join.

I am trying to build a list by fiscal quarter of when a customer was assigned to a specific sales person.  I need this list to track results for the salesperson.  Customers may move between sales people on a quarterly basis.  I have the tblFiscalQuarterMappingTable shown below to translate calendar months to fiscal quarters.  (Fiscal year is from September through August)

 tblFiscalQuarterMappingTable: 

My issue is the constituent_id used in the sample code below should return rows from quarter 1-2022 forward.  For some reason the result starts with fiscal quarter 2-2022 thereby not include quarter 1.  Please note the Constit_Solicitors.date_From field is in the format of YYYYMMDD and I am converting it in the code.

Code: 

SELECT        TOP (100) PERCENT dbo.Records.CONSTITUENT_ID,  Records_1.ORG_NAME, dbo.tblFiscalQuarterMapping.FiscalQuarter, 
                         dbo.tblFiscalQuarterMapping.FiscalYear, dbo.CONSTIT_SOLICITORS.DATE_TO, dbo.CONSTIT_SOLICITORS.DATE_FROM, CONVERT(date, dbo.CONSTIT_SOLICITORS.DATE_FROM, 120) AS ConvertedDateFrom
FROM            dbo.Records INNER JOIN
                         dbo.CONSTIT_SOLICITORS ON dbo.Records.ID = dbo.CONSTIT_SOLICITORS.CONSTIT_ID INNER JOIN
                         dbo.Records AS Records_1 ON dbo.CONSTIT_SOLICITORS.SOLICITOR_ID = Records_1.ID INNER JOIN
                         dbo.tblFiscalQuarterMapping ON 
                   
                  Convert(date,dbo.CONSTIT_SOLICITORS.DATE_FROM,120)<=QTRStartDate and (Convert(date,dbo.Constit_Solicitors.Date_TO,120)>=QtrEndDate or Date_To is null)
WHERE        (dbo.CONSTIT_SOLICITORS.SOLICITOR_TYPE = 10245)
GROUP BY dbo.Records.CONSTITUENT_ID, Records_1.ORG_NAME, dbo.tblFiscalQuarterMapping.FiscalQuarter, dbo.tblFiscalQuarterMapping.FiscalYear, dbo.CONSTIT_SOLICITORS.DATE_TO, 
                         dbo.CONSTIT_SOLICITORS.DATE_FROM
HAVING        (dbo.Records.CONSTITUENT_ID = '1131669')
ORDER BY dbo.tblFiscalQuarterMapping.FiscalYear, dbo.tblFiscalQuarterMapping.FiscalQuarter

Select allOpen in new window

The code returns:

 I cannot figure out why Fiscal Quarter 1-2021 is missing.

Thanks!