Display distinct date in list box

[#1]

Hi,

I am getting duplicate dates in a list box like this:

But I just want to show only distinct dates.

Do you know how to set it up?

Thanks in advance

[MayilVahanan · Accepted solution]

HI

Use

Load *, Floor(DateField) as DateField

from tablename;

Hope it helps

[hic]

These dates probably contain a time part also, that is hidden by the formatting. You need to create the field using Date(Floor(Date)).

See more on Why don’t my dates work?

HIC

[#4]

Yes, you solution worked.

Thanks a lot..

On Thu, Mar 21, 2013 at 7:50 PM, Henric Cronström

[#5]

Hi,

The following worked for me as an expression in the ListBox.

Date(floor(DATE_TIME_FIELD), 'MM/DD/YYYY')

Hope this helps someone.

[#6]

Yes, I have used the same expression in my ListBox while following your

help.

Thanks...