Whoopiee!! Now I understand! I don't know why but that was really bugging me. I have never done that before so I wasn't expecting that result. I guess I should stop playing with functions. hehe
Thanks a lot Phillip > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 05, 2002 3:55 PM > To: CF-Talk > Subject: RE: whats wrong with DateFormat() > > Thanks. This is why: > > day(now()) returned 5, because today is the fifth of the month. > > DateFormat(5, 'mm/dd/yy') would return 01/04/1900, because you have asked > for the fifth day, counting from 12/31/1899 (and if you want to read about > why that date was/was not chosen, there's lots to read!) > > DateFormat(day(now()), 'dd'), which is DateFormat(5, 'dd') returns 04, > because it is returning the 04 from 1/4/1900. > > Does that clear it up? > > 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:48 PM > To: CF-Talk > Subject: RE: whats wrong with DateFormat() > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
