Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement Logic
Message
From
15/02/2008 15:06:32
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
15/02/2008 14:37:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01292989
Message ID:
01293066
Views:
14
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
Map
View

Click here to load this message in the networking platform