Select box with date

[aa73]

Hello,

I have a problem to use select box with date (inside).
This is the properties of my select box :

select box.png (16.03 KiB) Viewed 1995 times

The field EXDEBEXE is a date.

When I run the programme the select containt this value :

select box 2.png (1.81 KiB) Viewed 1995 times

The problem is I want to have french format for date (d/m/y), and when I tried to select date, the system make an error :

select box 3.png (7.69 KiB) Viewed 1995 times

"Date is not valid"

Any solution for my problem ?

Thanks

[Scott Klement]

In the "value" property of the dropdown, there's a binding dialog where you can specify the format.

[aa73]

Thanks you M Klement.

I friends give me the solution.
In the "choice options fields" i put this : REPLACE(CHAR(EXDEBEXE, EUR), '.', '/')
In the "choice values fields" i put nothing.

And the programm work correctly.

Thanks