Rolling Dates in a Value List

[Corys]

Hello,

I am trying to setup a value list so there can be rolling Dates..

so..let's say we open the database on Monday the 16th, the options on the value list would be 16th,17th, 18th...etc..

then the next day, Monday the 16th dropped off and another day would be added to the tail end 17th,18th,19th ect..

Any Thoughts?

Thanks!

[bobsmith]

You could set up a calculated field to equal Status(currentDate)& (carraige return), Status (currentDate)+1 and return, etc for how ever may dates you wanted. Then you could base the value list from that field. Make your calculated field a text field but the data sould be read as a date when placed in a date field.