The value of column scheduledate = 12/30/1899 that is a DateTime field
I have this case statement
case when header.scheduledate = 18991230 then 'No' else header.scheduledate end as 'Future Order',
It is not producing my desired results which in this case is 'No'. In this case I am getting '11/1/2015' I have no idea where this date is even coming from?