Do you want to know the time when the form was 'opened' (viewed you mean) or actually saved? For example, I may hit your form at 12:01 PM, and it may take me 5 minutes to fill it out. So would you want 12:01 PM stored, or 12:06 PM, the time when the form was actually submitted? If you want the first time, simply eded this in the form:
<input type="hidden" name="theTime" value="#now()#"> and store form.theTime in your db. If you want the time submitted, just passed now() to your database (or whatever function your db uses to represent the current time). ======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED] > Sent: Monday, March 10, 2003 1:14 PM > To: CF-Talk > Subject: Inserting date/time stamp > > > Hi, > > I have a form that I want to insert the date and time when > the form is opened. This will also be saved to a database when saved. > > Whats the best way of also creating a "automatic" reference > no which increments when a "new" form is opened? > > Any ideas... > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4