I have a two fields called dateentered and datemodified. For dateentered field, I am using date() as default to that field. For datemodified, I am using in the update statement. But the problem is whenever I open that file, even when I am not making any changes, modified date is entered in to the database. Is there a way to modify only when data is being modified.
Thankyou.