Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
I need a special kind of index
Message
From
06/04/2006 08:36:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
I need a special kind of index
Environment versions
Visual FoxPro:
VFP 7 SP1
Miscellaneous
Thread ID:
01110927
Message ID:
01110927
Views:
48
The data I have is the following
   Date         Number of days
(MM/DD/YYYY)
------------------------------     
01/01/2006           150
01/05/2006           80
02/01/2006           10
I'd like it to to indexed so that the number of days is added to the date. This way I'll know just by looking at the first record (with that index) if some action has to be taken because the number of days since a given date has elapsed.

When browsing that data the result would be:
02/01/2006           10     Date + number of days is 02/11/2006
01/05/2006           80     Date + number of days is 03/26/2006
01/01/2006           150    Date + number of days is 05/31/2006
Easy way out of this?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé
Next
Reply
Map
View

Click here to load this message in the networking platform