What are you trying to do here? This will take the year of Temp_Date as a number (like 2018), and return a date 2018 days after the start of the date epoch (1 = 31 Dec 1900). I am sure that its not the desired result. Perhaps you mean
Date(MonthStart(Temp_Date), 'MM-YYYY') AS MMYYYY,
I assume the line is part of a fiscal year calculation.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein