Profound Logic Forums

Posted: **Fri Oct 22, 2021 3:50 am**

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 2172 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 2172 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 2172 times

"Date is not valid"

Any solution for my problem ?

Thanks

Posted: **Mon Oct 25, 2021 2:49 pm**

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

Posted: **Tue Oct 26, 2021 11:06 am**

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

Profound Logic Forums

Select box with date

Select box with date

Re: Select box with date

Re: Select box with date