Thread: How can I get user to enter date & time on a form?

date and time:   A free Dreamweaver Extension that adds a date picker to your form can be found here: http://www.michielvandijk.nl/downloads Works with javascript.

I have a form where I want the user to enter a date and time for an event. The database field is in MYSQL datetime format I've used the datepicker on the form field but it only allows for a date entry not time.(eeven when seetin the width to 22 chars I remember doing something before which allowed the user to pick a date and then add the time at the end.   I've got the date defaulted to dd/mm/yyyy and the time to H:mm in...

Two things: The column in your database is defined as DateTime, not Date You use the option on the Date Picker to choose datetime, not date   This will give the user the ability to choose a date and time from the date column.  If you need more control over the time, you probably need to add another column defined as Time.  Then you can use the validation rules to force an entry rather than allowing the default (current time).