with createDate() is midnight, which is probably just a few hours away?
Try setting today as createDate(year(now()), month(now()), day(now()))
_____
From: Matt Woodward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 June 2004 1:02 p.m.
To: CF-Talk
Subject: DateDiff Weirdness
I'm seeing some weird behavior with DateDiff that I hope someone can shed
some light on. I'm sure it's just a misunderstanding on my part but it just
doesn't do what I suspect that it should do.
Today is 6/22/2004, so if you're reading this on a different day, assume
that Now() is 6/22/2004.
Example 1: When I run this example, I would think that it would give me a
value of 1, but diff turns out to be 0.
date1 = CreateDate(2004, 6, 23);
date2 = Now();
diff = DateDiff("D", date2, date1);
Example 2: Given that the above example gives me a value of 0, I decided to
check to see what comparing the current date to itself would give (but again
using CreateDate to create one of the dates).
date1 = CreateDate(2004, 6, 22);
date2 = Now();
diff = DateDiff("D", date2, date1);
Again diff is 0. I guess this is my confusion--how can comparing the date
to itself AND the date to tomorrow BOTH give me a value of 0?
Example 3: To make sure it wasn't the CreateDate() function that was doing
something weird, I did the following, and it STILL gives me a value of 0:
date3 = DateAdd("D", 1, Now());
date4 = Now();
diff2 = DateDiff("D", date4, date3);
Example 4: Now for the total weirdness. When I put a couple of examples
together, one AFFECTS the other. In the first round, diff = 0 and diff2 =
1:
date1 = CreateDate(2004, 6, 22);
date2 = Now();
diff = DateDiff("D", date2, date1);
WriteOutput("diff = " & diff & "<br />");
date3 = DateAdd("D", 1, Now());
date4 = Now();
diff2 = DateDiff("D", date4, date3);
WriteOutput("diff2 = " & diff2 & "<br />");
But when I chnage it to this:
date1 = CreateDate(2004, 6, 23);
date2 = Now();
diff = DateDiff("D", date2, date1);
WriteOutput("diff = " & diff & "<br />");
date3 = DateAdd("D", 1, Now());
date4 = Now();
diff2 = DateDiff("D", date4, date3);
WriteOutput("diff2 = " & diff2 & "<br />");
BOTH diff and diff2 = 0. I've tried this on both CFMX 6.1 on Windows 2003
as well as BlueDragon on Mac OS X and I see the same behavior.
Again, I'm sure I'm just having a fundamental misunderstanding of DateDiff
since I've never had to mess with it much, so any enlightment on this will
be greatly appreciated.
Thanks,
Matt
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
