Hi
Is there a simple (dummies) way for me to update a datetime field with the current time if a checkbox has been ticked, and on retreival, show a tick if the the datetime field has a time in it?

<input type="checkbox" name="date_time" value="<%=Now%>">

Database type would have to be NVARCHAR or something other than datetime. If you were going to use datetime then

<input type="checkbox" name="date_time" value="<%=Date%>">
However you would only get the date in the database not the time.