Invalid default value for 'Date'
===

I want to set date as default value for date in mysql (not timestamp), but the following error appear

    alter table `RMS`.`transactionentry` 
    change `Date` `Date` date default 'Now()' NOT NULL

**Error**

    Invalid default value for 'Date'

**Same Case** 

    alter table `RMS`.`transactionentry` 
    change `Date` `Date` date default 'CURRENT_DATE' NOT NULL