Forums

This topic is locked

Updating a Date/Time field

Posted 19 Aug 2003 12:15:55
1
has voted
19 Aug 2003 12:15:55 Mark Saville posted:
Using the standard Dreamweaver Server Behaviour, I can create a database record with its date/time of creation, but an update form with an Update Behaviour doesn't update this date/time, despite setting the relevant form element to submit as "Date MS Access". The field data type in the Access database is set as Date/Time, with a default value of Now()

Is this a common problem? I'm a newbie to this and have very little hair left.

Replies

Replied 20 Aug 2003 16:17:27
20 Aug 2003 16:17:27 Vince Baker replied:
place a hidden field inside your form and add the following into the value

<%=Now%>

or for just the date

<%=Date%>

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting
Replied 20 Aug 2003 17:57:31
20 Aug 2003 17:57:31 Mark Saville replied:
Thanks Vince - the form works fine now. Much appreciated.

Reply to this topic