How to use "Distinct" to exclude duplicate values

[srinivas91k]

Distinct : How to use "Distinct" to exclude duplicate values from table field. please find the snap , field timeFormat having duplicates i want to display unique values from this.

[Gysbert_Wassenaar]

Use the Year function: year(TimeFormat)

Merely formatting the function with Date(TimeFormat, 'YYYY') doesn't change the real value, only the formatting. That's why the values in the listbox seem to be the same, but they are still different and therefore shown individually in the listbox.