Duplicate date entries on List Box

[#1]

Hi all,

I have a strange behavior with one of my tables its shows duplicate entries as on the bellow image.

I should have an entry for each date.

Any help will be much appreciated.

[#2 · Accepted solution]

hey Andrei,

Its because of the timestamp attached with the date. User Floor(Field). This will remove the time portion attached to the date.

Thanks

AJ

[#3]

Hi Ajay,

Many thanks. That worked perfectly.

Andrei