Strange DATE Function Behaviour

Hi all, looking for a sanity check and hopefully an explanation on the below.   I have a Date table with: Column Name (Column Type) Date (Date) Year (Whole Number) MonthOfYear (Whole Number) ...