Boomer Advisor
DataBased Advisor
FileMaker Advisor
Advisor Basics of FileMaker Pro
How-To CDs
Advisor Store: Subscriptions & CDs
Help
You are here:
My.Advisor.com
»
Guides
»
DataBased Advisor
»
Microsoft Visual FoxPro Testing with Empty Dates
My.ADVISOR.com Sign-In
ID
Password
Member Center / Sign-Up
Go to Article
Advanced Search
Jump to . . .
My.ADVISOR.com -- Business Technology
Search Articles
Advisor Academy
Advisor Onsite
Business Collaboration Advisor
Compliance Solutions Advisor
E-Discovery Advisor
Law Technology
Security Advisor
Business Advisor
DataBased Advisor
IBM WebSphere Advisor
Mobile Business Advisor
FileMaker Advisor
FileMaker Pro Basics Advisor
IBM Lotus Advisor
Microsoft Access Advisor
Microsoft Office System Advisor
Microsoft Pro Development Advisor
Microsoft SharePoint Advisor
Microsoft Visual Basic .NET Advisor
Microsoft Visual FoxPro Advisor
Microsoft Visual Studio Advisor
Novell GroupWise Advisor
BOOMER ADVISOR
Entertainment Advisor
Caregiver Advisor
Food Advisor
Generations Advisor
Health Advisor
HomeLiving Advisor
Lifestyle Advisor
Money Advisor
Dogs Advisor
Pets Advisor
Fun Advisor
Recreation Advisor
RV Advisor
Computer Advisor
Boomer Advisor
Community Advisor
Family Advisor
Retirement Advisor
Senior Solutions Advisor
Work Advisor
Travel Advisor
MORE RESOURCES
Complete Advisor CDs
CUSTOMER SERVICE
Advisor Help
Member Center
Advisor FAQ
Store Purchase Policies
Advisor Domains Store
ADVISOR MEDIA
About Advisor Media
About Advisor Network
Advisor's San Diego
Writer Information
Privacy
Trademarks
Terms of Use
Site Map
Link to
DataBased Advisor
Submit your How To tips and advice
ADVISOR TIPS
Microsoft Visual FoxPro Testing with Empty Dates
VFP’s BETWEEN() function is useful for checking to see if a date lies within a given range, but it doesn't handle empty dates very well.
Martin Griffin
THIS ARTICLE IS SUBSCRIBER-ONLY
To read this article you must have a current Subscription or Passport for:
DATABASED ADVISOR
or
MICROSOFT PRO DEVELOPMENT ADVISOR
or
MICROSOFT VISUAL FOXPRO ADVISOR
or
MICROSOFT VISUAL STUDIO ADVISOR
If you have a correct subscription, sign-in (pink box above) to view the complete article and access any Download.
Purchase or renew your Subscription or Passport at www.AdvisorStore.com
.
Click this link for help with subscriber online access
.
About this Article:
Here's how to to pass an empty date as the end of the range, and have it treated as the highest possible date; that is, it would always be considered higher than the date under test.
Keyword Tags: Microsoft Visual FoxPro, Testing
ADVISORAMA
If a little knowledge is dangerous, a lot of dangerous people are wandering around.
Refresh (F5) for more
Contribute
Advisor Solutions
BOOMER ADVISOR
- NEW: The practical guide to Boomer lifestyle, work, play, including helping your senior family members. Learn what you need to know and how to do what you want to do.
FILEMAKER PRO BASICS
- NEW: The simple guide to using FileMaker Pro. See how to do what you want to do, fast and easy.
ARTICLE INFO
DataBased Advisor
Web Edition: 2007 Week 40, Doc #19287
Print Edition: September 2007
ARTICLE LOCKED
SUBSCRIPTION STATUS
You are not signed-in. If you are a subscriber to this publication, sign-in above to access locked articles. To subscribe or renew go to
www.AdvisorStore.com
.
MORE ADVISOR
Advisor on Microsoft Visual FoxPro
Advisor on Testing
ARTICLE ACCESS
= free access
= subscriber-only
= not online (on CD or in print)
= has download
DataBased Advisor How-To Library by Topic Keywords
Subscribe to DataBased Advisor Magazine
Get subscriber online access to articles
DataBased Advisor Forum
Free e-newsletters on business, technology & lifestyle
Special Offers
GET ADVISOR ANTHOLOGIES ON CD
- Have it all, at your fingertips: how-to articles, clever tips, useful files. Complete Advisor CDs are available now!
RSS FEEDS
- Look for the RSS icons to get ADVISOR headlines on your desktop.
Subscribe to FileMaker Advisor Magazine
Read the advanced guide to creating custom business database solutions with FileMaker software. Subscribe now to gain access to all the archives and downloads.
FileMaker.Advisor.com
Subscribe to Advisor Basics of FileMaker Pro
Learn the fundamentals of using FileMaker Pro software. Every issue gives you step-by-step instructions on creating the databases you need. Subscribe now!
FileMaker.AdvisorBasics.com
Showcase Your Smarts
Submit your tips, techniques and advice and let Advisor promote your business and build your career. Show the world what you know!
AdvisorTips.com
Site Map
Advisor Store
Privacy
Terms of Use
Trademarks
Advertising
About Advisor Media
Advisor's San Diego
Advisor Basics of FileMaker Pro
|
Boomer Advisor
|
Business Advisor
|
Business Collaboration Advisor
|
Business Security Advisor
|
Caregiver Advisor
|
Community Advisor
|
Compliance Solutions Advisor
|
Computer Advisor
|
DataBased Advisor
|
DataBased Advisor
|
Dogs Advisor
|
E-Discovery Advisor
|
Entertainment Advisor
|
Family Advisor
|
FileMaker Advisor
|
Food Advisor
|
Fun Advisor
|
Generations Advisor
|
Health Advisor
|
HomeLiving Advisor
|
IBM Lotus Advisor
|
IBM WebSphere Advisor
|
Law Tech Advisor
|
Lifestyle Advisor
|
Microsoft Access Advisor
|
Microsoft Office Advisor
|
Microsoft Pro Development Advisor
|
Microsoft SharePoint Advisor
|
Microsoft Visual Basic .NET Advisor
|
Microsoft Visual FoxPro Advisor
|
Microsoft Visual Studio Advisor
|
Mobile Business Advisor
|
Money Advisor
|
Novell GroupWise Advisor
|
Pets Advisor
|
Recreation Advisor
|
Retirement Advisor
|
RV Advisor
|
Senior Solutions Advisor
|
Travel Advisor
|
Work Advisor
Use of this or any other site, content, product or service of Advisor Media constitutes acceptance of Terms of Use.
Portions copyright ©1983-2008 Advisor Media, Inc. All Rights Reserved.
Reuse or reproduction of any portion or quantity of Advisor Media's copyrighted content, in any form, for any purpose, requires written permission.
ADVISOR®, the ADVISOR logo, and other names and logos that incorporate ADVISOR are registered trademarks, trademarks or service marks of Advisor Media, Inc. in the United States and/or other countries.
Other trademarks are used for identification, editorial or descriptive purposes and are the property of their owners.
Advisor expert advice, know-how, tips, news, training, help, and more.
Website powered by
ztmsvftips-03 posted 11/05/2007 modified 12/03/2008 03:40:41 AM ztdbms/ztdbms
domino-144.advisor.com my.advisor.com 12/03/2008 06:54:50 PM