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
<%=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.