date field not been updated

please am using an before insert event to update another table while it inserts same data into another table. but the date field returns 0000.00.00 after other fields are updated correctly. please how can i solve this?