List box with date - contains dates at lowest level

[helen_pip]

Hello

I want to create a list box for Day.....There will be an additional list box where the user can sleect month, so only dates in that month are displayed

However my data is at lowest level I.e. I can idnetify people in my data and therefore when i choose data in my list box, it displays it for as many people I have in my data set

I.e.

24/02/2013

24/02/2013

24/02/2013

24/02/2013

24/02/2013

25/02/2013

25/02/2013

25/02/2013

How Do I get the date in the list box to just show

24/02/2013

25/02/2013?

Many Thanks

Helen

[Gysbert_Wassenaar · Accepted solution]

Remove the time fraction from the date in the script: floor(MyDate) as MyDate

(replace MyDate with the name of your field)

[helen_pip]

Hello

Thanks for your response

However I now get

41005

41005

41055

41055

I have tried Floor(MyDate) as Date

                Floor(Date(MyDate,'DD/MM/YYY')) as Date

Am I doing something wrong?

Thanks

Helen

[helen_pip]

Hello

Thanks for your response

However I now get

41005

41005

41055

41055

I have tried Floor(MyDate) as Date

                Floor(Date(MyDate,'DD/MM/YYY')) as Date

Am I doing something wrong?

Thanks

Helen

[helen_pip]

Hello

Thanks for your response

However I now get

41005

41006

41057

41058

I have tried Floor(MyDate) as Date

                Floor(Date(MyDate,'DD/MM/YYY')) as Date

Am I doing something wrong?

Thanks

Helen

[helen_pip]

Hi

Ignore me, it is now working O.K.

Thanks for your help

Thanks

Helen

[Jason_Michaelides]

Please mark a correct answer to close the thread. This way people searching can see this thread was answered.