distinct values from a field in list box

[#1]

Hi All,

How to show distinct values from a field in list box?

Thanks in advance.

[nagaiank · Accepted solution]

Try the following expression:

Date(Floor(OrderDate))

[#3]

I tried but still it is showing duplicate values in list box.

[nagaiank]

Is it possible to post a few rows of your data containing the field to be used in the list box?

[#5]

Thank you dear Nagaian K. It has worked.

[MarcoWedel]

Also possible:

DayName(OrderDate)

Hope this helps

Regards

Marco