Can someone tell me what result this produces?
I am getting no records.
CASE WHEN MONTH(GETDATE()) <= 7 THEN DATEFROMPARTS(YEAR(GETDATE()) , 6 , 30) ELSE DATEFROMPARTS(YEAR(GETDATE()) + 1 , 6 , 30) END OR IS NULL
I want to see all records with EndDates as specified in the criteria but it is returning no results.
However, before 2017 I was getting results.
I think that it's saying to display records where the EndDates are less than July ending 6/30/ of current year otherwise display where the EndDates are in the future year ending 6/30/ next year
So if today is less than the month of July it looks at EndDates with 6/30/2017 otherwise looks at EndDates with 6/30/2018 or if it’s NULL