[AccessD] Loop Until Date=Date

Mark A Matte markamatte at hotmail.com
Wed Jan 23 10:31:30 CST 2008


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
>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

_________________________________________________________________
Helping your favorite cause is as easy as instant messaging. You IM, we give.
http://im.live.com/Messenger/IM/Home/?source=text_hotmail_join



More information about the AccessD mailing list