Unable to read date '1900-01-01' in sql server

Question

 

SELECT * FROM WeekMaster WHERE CAST(GETDATE() AS DATE) BETWEEN CAST(DateFrom AS DATE) AND CAST(DateTo AS DATE)

AND CourseId=95

 

I am using above sql query for cast date and on the basis of this i get details from table but when i insert  '1900-01-01' as date in date column query  unable to read that raws field ?

 

please help if possiable or suggest me to resolve this