July 3, 200322 yr How could I have a rolling 5 day [color:"black"] date (03/07/2003.....) value list that would perpetually change
July 4, 200322 yr I'd do this with 5 buttons, designed to look like a list. Each would contain an unstored calculation field which would be: Date_1 = Status(CurrentDate) + 1 Date_2 = Status(CurrentDate) + 2 etc Then write a script for each button which Sets your required date field to the date in question. You could also create some "Today", "Tommorrow" and "Yesterday" buttons in the same fashion. If screen real-estate is at a premium, create a duplicate layout to which the user is taken when they click in the date field. This would display the list. Have emailed you a file.
Create an account or sign in to comment