You should probably think of the hidden date/time field and the displayed date/time as two separate things. For the second, you always need to format a date and time before outputting it to screen, e.g.:
#dateformat(now(), "dddd, mmmm d, yyyy)# at #timeformat(now()) Matthew Walker Electric Sheep Web http://www.electricsheep.co.nz/ ----- Original Message ----- From: "FlashGuy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 11, 2003 8:26 AM Subject: RE: Inserting date/time stamp > Hmmm....I also want the date and time displayed on my form. I did a <cfoutput>#now()#</cfoutput> but I don't like the results. > > I want something like: > > Monday, March 10, 2003 at 2:26pm > > > > On Mon, 10 Mar 2003 13:19:13 -0600, Raymond Camden wrote: > > > 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4