Creating a value list that is always the past 7 days?

[HALBURN]

Is there a way to create a value list that always shows the current date and

the last 7 days?

I need a short popup menu that users can select from to filter portal results for the current date and the past 7 days.

[Ocean West]

Several ways....

On startup go to a utility table purge all records and then create 7 records starting from today - 7. Then create a value list that shows all values from the field. This wouldn't require the table to be tied to every TOG.

You could create a utility table that has a record for each date for the next few years, then a relationship that does a range filter based upon a global field that you set at startup. Base your value list off the relationship.

Use a plugin that allows you to create a value list from a field/variable.

Edited February 14, 2008 by Guest

[mr_vodka]

If you create a global date field and on your startup script, you set it to the current date, you can try this:

A repeating calc with date result (7 reps)

gCurrentDate - 7 + Get ( CalculationRepetitionNumber )

Then on your value list, you can specify the repeating field.

[HALBURN]

Awesome! Thanks.