I'm trying to create a list of years based on a date field in one of my tables.

I am putting a dashboard together that allows the user to select the starting year from a drop down list. Each user will possibly have a different range of dates in their copy so i would like to have a drop down list of years based on the dates in a field in their copy.

I hope that makes some sense and someone can point me in the right direction?

Thanks

A calculation field (unstored, text)

YearList = Year(Get(currentDate))-2 & "¶" & Year(Get(currentDate))-1 & "¶" & Year(Get(currentDate)) & "¶" &Year(Get(currentDate))+1 & "¶" &Year(Get(currentDate)+2

will give you a list of years from 2 years ago to 2 years hence. Adjust the range as needed.

Then create a value list using values from YearList.

i would like to have a drop down list of years based on the dates in a field

Define a calculation field (result is Number) =

Year ( Datefield )

and a value list based on this field.

A calculation field (unstored,

...

Then create a value list using values from YearList.

Have you tried this?

Apologies. My original calculation that has been in use for years set a field YearListSeed in a startup script, and built the calculation from that. One of these days I'll stop shooting from the hip.

Thanks guys...Appreciate the help.