value list and date display

[gemgon]

Hi all,

is there a possibility to have a value list with the date of tomorrow, today and yesterday displayed?

At the moment I am using a value list with text (tomorrow, today, yesterday) as a pop-up and dependent on the selection I insert the date via a formula in another field.

But I would rather like to have the actual date displayed in the pop-up.

tnx for your help

[Lee Smith]

You could have the words Yesterday, Today and Tomorrow in the value list, and then have a Field display the results based on the valud list.

Case(YourField= "Yesterday", Status(CurrentDate) - 1,

YourField= "Today", Status(CurrentDate),

YourField= "Tomorrow", Status(CurrentDate)+1)

HTH

Lee

[Ugo DI LUCA]

Hi Gemgon, Hi Lee,

You could keep Lee's idea, but storing these records in another file called "Dates" with only three records in it.

Three records text "yesterday, today, tomorrow" and Lee's calc.

Then pick-up the calc field for your value list in the current file :

- using records from file "Dates"

- using a value list from file "Dates" (if you defined these records as a value list in File "Dates".

[gemgon]

this works .....thanks a lot :-)