Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DateTime Range Challenge
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00807668
Message ID:
00807747
Views:
18
>You can use two betweens with an or seperating them.
>between(tBegin,tUserStart,tUserEnd) OR between(tEnd,tUserStart,tUserEnd)


Yes, except for the case when tBegin is before tUserStart and tEnd is after tUserEnd. I forgot to include this in my graphic example.

01110000000000 <- record excluded
00000000001111 <- record excluded
00111111111000 <- record included

Thanks,
Randy Bosma
VFP - Because life is too short to code in something else...
Previous
Reply
Map
View

Click here to load this message in the networking platform