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 > > > > > > > > > > > ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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?sidebar=lists