i like the date to auto populate in one of the box in a form so it will require one less interaction for a user. thanks.

Try:

<input type="text" name="textfield" value="<% = Date() %>">

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Owen, this is great, but i need this in database friendly (smalltime) format. Any idea. I have tried this value="<%= DoDateTime((changeform.Fields.Item("date".Value), 1, 4105) %>" but the time result is inconsistent. thanks in advance.

Store date value as it is and format it later directly on page. It's not the question how you store it, it's the question how you display it.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Owen, this is great, but i need this in database friendly (smalltime) format. Any idea. I have tried this value="&lt;%= DoDateTime((changeform.Fields.Item("date".Value), 1, 4105) %&gt;" but the time result is inconsistent. thanks in advance.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>