I should have been more specific. It gave me 04. 

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 3:23 PM
> To: CF-Talk
> Subject: RE: whats wrong with DateFormat()
> 
> OK, did it give you yesterday's date, 3/4/2002, when you put in
> DateFormat(day(now()), 'dd'), or did it give you 04?
> 
> 
> Kathryn Butterly
> Web Developer
> Washington Mutual Finance
> 813 632-4490
> [EMAIL PROTECTED]
> 
> 
> -----Original Message-----
> From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 05, 2002 4:19 PM
> To: CF-Talk
> Subject: RE: whats wrong with DateFormat()
> 
> 
> So can some one explain why I would get yesterdays date when I use
> DateFormat(day(now()), 'dd')???
> 
> > -----Original Message-----
> > From: Bill Grover [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, March 05, 2002 2:38 PM
> > To: CF-Talk
> > Subject: RE: whats wrong with DateFormat()
> >
> > The reason is how dates are stored.  Dates are stored as sequential
> > numbers.
> > You are passing the sequential number 5 into the routine which
> > Dateformat
> > thinks is something weird like 1/4/0001 or some such weird number.
> >
> > You need to pass the true datetime variable.  Date format will only
> > return
> > the day portion anyhow, you don't need to pull the day out before
> > formatting
> > it.
> > ______________________________________________________
> >
> > Bill Grover
> > Supervisor MIS                  Phone:  301.424.3300 x3324
> > EU Services, Inc.               FAX:    301.424.3696
> > 649 North Horners Lane          E-Mail: [EMAIL PROTECTED]
> > Rockville, MD 20850-1299        WWW:    http://www.euservices.com
> > ______________________________________________________
> >
> >
> >
> > > -----Original Message-----
> > > From: Phillip Broussard [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, March 05, 2002 11:33 AM
> > > To: CF-Talk
> > > Subject: RE: whats wrong with DateFormat()
> > >
> > >
> > > I can understand why the number 5 may not work but when I use
> > > DateFormat(day(now()), 'dd') I still get a date of yesterday.
> > > This just
> > > doesn't seem right.
> > >
> > > Phillip
> > >
> > > > -----Original Message-----
> > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > > > Sent: Tuesday, March 05, 2002 10:25 AM
> > > > To: CF-Talk
> > > > Subject: Re: whats wrong with DateFormat()
> > > >
> > > > The function day() returns a simple number between 1 and 31.  It
> > > >
> > > > expects a date/time object.  The number "5" is a date/time
object,
> > > >  but
> > > >
> > > > it doesn't represent the day "4".
> > > >
> > > > The function dateformat expects a date/time object, a string
that
> > > looks
> > > >
> > > >
> > > > like a date, or a numeric representation of a date object.
> > > I guess t
> > > > he
> > > >
> > > > number "5" has a day of "4".
> > > >
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Phillip Broussard <[EMAIL PROTECTED]>
> > > > Date: Tuesday, March 5, 2002 9:15 am
> > > > Subject: whats wrong with DateFormat()
> > > >
> > > > > Ok I put DateFormat(day(now()), 'dd') on a page and instead of
> > > >
> > > > > returning05 it gave me 04.
> > > >
> > > > > If I put day(now()) on a page I get 5.
> > > > > If I put day(5) on a page I get 4.
> > > > > If I put DateFormat(now(), 'yyyymmdd') on a page I get
20020305
> > > >
> > > > >
> > > >
> > > > > Why?
> > > >
> > > > >
> > > >
> > > > > TAI
> > > > >
> > > >
> > > > > Phillip Broussard
> > > > > Tracker Marine Group
> > > > > 417-873-5957
> > > > >
> > > >
> > > > >
> > > >
> > > > > _______________________
> > > > _________________________
> > > > ______________________
> > > > > Dedicated Windows 2000 Server
> > > > >  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
> > > > >  Instant Activation . $99/Month . Free Setup
> > > > >  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
> > > >
> > > > > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion
> > > > com/
> > > > > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb
> > > > ar=lists
> > > > >
> > > >
> > >
> >
> >
> 
> 
______________________________________________________________________
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation � $99/Month � Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists


Reply via email to