[AccessD] Loop Until Date=Date

Hi Mark

But what about: CDbl(RecordDT - RecordDT_end)?

/gustav

>>> markamatte at hotmail.com 23-01-2008 17:31:30 >>>

That was the first thing I did...both are showing 12/17/2007 4:30:00 PM...but the "=" fails.

Thanks,

Mark A. Matte


> Date: Wed, 23 Jan 2008 11:22:05 -0500
> From: fuller.artful at gmail.com 
> To: accessd at databaseadvisors.com 
> Subject: Re: [AccessD] Loop Until Date=Date
>
> I would add a Debug.Print statement at the top or bottom of the loop to
> print out both values in Long Date format so you can see all the particulars
> of both values. That should reveal the difference, and why equality is
> failing.
>
> A.
>
> On 1/23/08, Mark A Matte  wrote:
>>
>>
>> Hello All,
>>
>> Thanks for the suggestions. I found last night that "DateDiff("s",
>> RecordDT, RecordDT_end) = 0" would work...but I just can't seem to
>> understand why they were not equal. I tried the suggestion below...but it
>> failed as well. I also tried "If RecordDT>= RecordDT_end"...this
>> works...but scares me because I don't know why it works and "=" does not. I
>> think I will just use the datediff approach...but am still curious...
>>
>>
>> Thanks,
>>
>> Mark A. Matte