>> 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 >>>>
>INDEX ON DTOS(Date+NumberOfDays) TAG .... >Thank you Borislav.