Complete the following steps and you are done:
- Right click on the name of table
- select design
- click on field where you want to create auto entry of current date
- now look in the “Column Properties” window
- Under the General group there is property called “Default value or Bindind”
- in that type in “(getdate())” and save.
You can use getdate() function in the insert query too.