Page 1 of 1

Select box with date

Posted: Fri Oct 22, 2021 3:50 am
by aa73
Hello,

I have a problem to use select box with date (inside).
This is the properties of my select box :
select box.png
select box.png (16.03 KiB) Viewed 2169 times
The field EXDEBEXE is a date.

When I run the programme the select containt this value :
select box 2.png
select box 2.png (1.81 KiB) Viewed 2169 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
select box 3.png (7.69 KiB) Viewed 2169 times
"Date is not valid"

Any solution for my problem ?

Thanks

Re: Select box with date

Posted: Mon Oct 25, 2021 2:49 pm
by Scott Klement
In the "value" property of the dropdown, there's a binding dialog where you can specify the format.

Re: Select box with date

Posted: Tue Oct 26, 2021 11:06 am
by 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