its a little bit confusing that you name field date, but use datetime field type, then what client want date or datetime there?