this is so weird to me! ok, i changed not null to YES and put now() in default. it still filled with 0000-00.... when i added a record. then i did resync database. it changed column properties not null to NO and default value to 0000-00-00.... but now it works. i don't understand, but it works. thanks!