Month and Year listbox selection

[#1]

Hi,

This seems like a basic question as this feature seems to be common.  I've seen this accross the top of most example dashboards. 

How can I take a sales date column and create a listbox that contains unique values of the dates in both month spelled out (Jan) format and YYYY.

Also, how do you make the listbox horizontal instead of vertical?

Thanks.  

[johnw]

The field names are the part in [] after "as" in each of the loads, or just the name given in the source file if there is no "as".  You'll see them when you build a list box, so once you've run the script, it shouldn't be confusing.  They'll be these for the above example:

ID

Term Date

Term Month

Term Year

The second script I gave includes the years associated with the months.  The first does not.