Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I got to it before reading your post, but that's exactly what was needed. Thanks!
>A couple of ideas:
>
>1. It might simplify things if you can convert the separate date and time variables into DateTime variables
>
>2. I haven't looked at your code too closely, but I've had similar time span logic cases to deal with in the past. The logic I use is:
>
>- all or part of my test time span A is in time span B if:
>
>- either A.Start or A.End is between B.Start and B.End, OR
>- A.Start < B.Start AND A.End > B.End
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only