Select box with date

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
aa73
New User
Posts: 19
Joined: Fri Aug 23, 2019 5:13 am
First Name: Alexis
Last Name: ALABERT
Company Name: LOISELET & DAIGREMONT
Country: France
Contact:

Select box with date

Post 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 2122 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 2122 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 2122 times
"Date is not valid"

Any solution for my problem ?

Thanks
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Select box with date

Post by Scott Klement »

In the "value" property of the dropdown, there's a binding dialog where you can specify the format.
aa73
New User
Posts: 19
Joined: Fri Aug 23, 2019 5:13 am
First Name: Alexis
Last Name: ALABERT
Company Name: LOISELET & DAIGREMONT
Country: France
Contact:

Re: Select box with date

Post 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
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 0 guests