You can't. Even the stored procedure approach that Prerak recommends has a fatal flaw: there is no SQL date format that allows year or month zero. See
MSDN[
^]
I would strongly recommend that you instead return a number of days between the two dates
SELECT DATEDIFF(day, [date], GETDATE()) FROM myTable
and process that into a date if you really need it.