Dynamic Value List - Date Calculation

[duncandawg]

I would like to create a pop-up value list which is simply about a half dozen years to choose from, starting with next year, but changing each year depending on the date. For example, this year, the user enters the field and they can choose from 2003, 2002, 2001, 2000, 1999, 1998... but next year, the same field would supply six sequential year choices starting with 2004 and ending with 1999. Anyone know how I can do this in a value list? I assume I must select use values from a field, then create a calculation field and use Year(Today) but then what? Year(today) + 1 etc. etc. doesn't seem to work. I don't know how to make a calculation field return multiple values either.

Thanks in advance for anyone's suggestions.

Chris. (BTW - Duncan is the name of my Golden Retriever)

[djgogi]

quote:

---

Originally posted by Duncan:

I would like to create a pop-up value list which is simply about a half dozen years to choose from, starting with next year, but changing each year depending on the date. For example, this year, the user enters the field and they can choose from 2003, 2002, 2001, 2000, 1999, 1998... but next year, the same field would supply six sequential year choices starting with 2004 and ending with 1999. Anyone know how I can do this in a value list? I assume I must select use values from a field, then create a calculation field and use Year(Today) but then what? Year(today) + 1 etc. etc. doesn't seem to work. I don't know how to make a calculation field return multiple values either.

Thanks in advance for anyone's suggestions.

Chris. (BTW - Duncan is the name of my Golden Retriever)

---

Create an file Years.fp5 with as many records you wish to display in pop-up list with calc field years defined in this way:

code:

---

years=Year(Status(CurrentDate))+Status(CurrentRecordCount)-Status(CurrentRecordNumber)

and make result calculation as number.

Than in your main file create list "year" as using values from field "years" from file years.fp5

Well this won't reverse the display order since FM apply default ascending order when indexing an field ( you can change the set of characters to use for indexing but not the order).

So if you really really need the display in reversed order, than consider using portal (because you can define sort order) instead of pop-up list

HTH

Dj

[ April 07, 2002, 11:54 PM: Message edited by: dj ]

[duncandawg]

Thanks so much! You really know this program.

Chris