No the time stamp wont work in this instance.
On the form where the users enter the information use Validation Toolkit to apply Client side validation.
Use Date time client side validation to validate the entered date.
Set ti to allow mm/dd/yyyy to be entered.
And set the reformat option to yyyy/mm/dd. This will convert the entered date to the MySQL Format when the form is submitted.