>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?
INDEX ON DTOS(Date+NumberOfDays) TAG ....
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
