whats wrong with DateFormat()

2002-03-05 Thread Phillip Broussard
Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 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(), 'mmdd') on a page I get 20020305 Why? TAI Phillip Broussard Tracker Marine Group 417-873-5957

RE: whats wrong with DateFormat()

2002-03-05 Thread David Schmidt
Just to confirm this, I get 04 also... -Original Message- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:16 AM To: CF-Talk Subject: whats wrong with DateFormat() Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 it gave me

RE: whats wrong with DateFormat()

2002-03-05 Thread Paul Melanophy
: whats wrong with DateFormat() Ok I put DateFormat(day(now()), 'dd') on a page and instead of returning 05 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(), 'mmdd') on a page I get 20020305 Why? TAI Phillip Broussard

Re: whats wrong with DateFormat()

2002-03-05 Thread ksuh
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

RE: whats wrong with DateFormat()

2002-03-05 Thread Phillip Broussard
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

RE: whats wrong with DateFormat()

2002-03-05 Thread Garza, Jeff
the desired result 5? Cheers, Jeff Garza -Original Message- From: Phillip Broussard To: CF-Talk Sent: 3/5/02 9:33 AM 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

RE: whats wrong with DateFormat()

2002-03-05 Thread Bill Grover
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

RE: whats wrong with DateFormat()

2002-03-05 Thread Phillip Broussard
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

RE: whats wrong with DateFormat()

2002-03-05 Thread kbutterly
: 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

RE: whats wrong with DateFormat()

2002-03-05 Thread Jerry Johnson
[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

RE: whats wrong with DateFormat()

2002-03-05 Thread Phillip Broussard
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

RE: whats wrong with DateFormat()

2002-03-05 Thread kbutterly
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

RE: whats wrong with DateFormat()

2002-03-05 Thread Phillip Broussard
]] 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