[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 <markamatte at hotmail.com> 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
>
>