Distinct selection in a List Object

[Anonymous]

I create a list with a date field from a table and I formated the list content to show only months "MMM".

The problem is that this field have several itens from the same month and I want to see only one copy of all valid months.

Like:    select distinct month(datefield) from table

[swuehl]

You are using the number format tab in list box properties, right?

try using a list box field expression instead (on general tab, select <expression> from the field drop down) and enter:

=month(YOURDATEFIELD)

or

=Date(monthstart(YOURDATEFIELD),'MMM')

or

=monthname(YOURDATEFIELD)

You could also add a field to your table using

LOAD

...

YOURDATEFIELD,

month(YOURDATEFIELD) as Month

from Table;

and just use this field in the list box.