Date Number of days (MM/DD/YYYY) ------------------------------ 01/01/2006 150 01/05/2006 80 02/01/2006 10I'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.
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/2006Easy way out of this?