Creating Drop Down Date Range Lists from calculations based on the Current Date
Sorry about the long title.
I have created a calculation that allows me to set a Date Range (MM/DD/YYYY...MM/DD/YYYY) based on the Current Date. It will allow you to choose Yesterday, Today, Tomorrow, Last Week, This Week, Next Week, Last Month, This Month, Next Month, Quarter 1, Quarter 2, Quarter 3, Quarter 4, Last Year, This Year, Next Year (of course, you can also enter any date range you wish). Via a trigger script it displays the correct Date Range. It is very useful in Finds, Reports, etc. I genreally use it as a global field and make it available throughout the solution.
What I would like to do now is provide a Drop Down Menu with these values all calculated out so that my users could select them directly without having to click around. The only way I can think to do it is to create a little table that has these values as records that populate a Value List. That seems a little clunky.
Surely there is a better way!