Hello,
I have a problem to use select box with date (inside).
This is the properties of my select box :
The field EXDEBEXE is a date.
When I run the programme the select containt this value :
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 :
"Date is not valid"
Any solution for my problem ?
Thanks
Select box with date
-
- 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:
-
- 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
In the "value" property of the dropdown, there's a binding dialog where you can specify the format.
-
- 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
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
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
Who is online
Users browsing this forum: Bing [Bot] and 0 guests