You need to format it.

#DayOfWeekAsString(Now())#, #DateFormat(Now(),"mmmm d, yyyy")# at
#TimeFormat(Now(),"h:mmtt")#

> -----Original Message-----
> From: FlashGuy [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 10, 2003 2:27 PM
> To: CF-Talk
> 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
                                

Reply via email to