Annemie19

Hi There, 

I have the following table that I created from the below query

SELECT
d.DealID, 
d.DealNumber, 
d.NominalAmount, 
--i.StartDate,
DATEADD(day, -1, i.EndDate) AS [AdjustedEndDate], 
i.Rate, 
cp.ProjStartDate, 
cp.ProjEndDate, 
dir.InterestMultiplier 

from [dbo].[VwPrefSharesDeal] d
JOIN VwPrefSharesCashProjection cp on cp.DealHashKey = d.DealHashKey
JOIN [dbo].[VwPrefSharesDealInterBankRelation] dir ON d.DealHashKey = dir.DealHashKey
JOIN [dbo].[VwPrefSharesBank] b ON dir.InterestBankHashKey = b.BankHashKey
JOIN [dbo].[VwPrefSharesInterest] i ON b.BankHashKey = i.BankHashKey

WHERE DealID = 'SI001263-03'
and ProjStartDate = '2020-03-31 23:59:59.0000000'
ORDER BY i.StartDate

I want to show the start date as the ProjStartDate = '2020-03-31 23:59:59.0000000' when the ProjStart date is after the startdate and the AdjustedEndDate as and ProjEndDate = '2020-09-30 23:59:59.0000000'. 

For instance, I only want to see the following dates

I have tried Case When, but I cannot get it to work.