The solution that worked before upgrading to R2.2 and a MySQL database restore, used to display dates in format dd-MM-yyyy (DATETIME)
The date format in the MySQL database is yyyy-MM-dd (DATE)
We never had a problem so far
But now the forms open correctly but DO NOT SHOW the date anymore
All other fields are showing
I tried everything so far , no result. Even a new test form displaying all the providers in the repository concerned. No luck.
What am i missing ?
Client is able to enter dates in the fields, checking the MySql database show all data is available.
I had a very similar problem with Postgresql 8 and Servoy 2.2. Not sure whether it is 2.2 specific or also would have caused a problem on earlier versions, I didn’t try it. I s
Solved it by changing the default date format in Postgresql to the European format dd-MM-yyyy and restarting the database server.
I am experiencing this exact problem - dates do not appear in the fields when data is retrieved, but are saved if a new date is entered. My software versions are the same as above (namely, MySQL 3.23), except I am using the 2.2 release. I tried changing the format under Servoy’s Locale tab to “yyyy-MM-dd” to match MySQL, and the fields were already set to a DATETIME type in Servoy… still no luck, I’m afraid. Even when retrieving the fields in question as strings, they all have null values.
I can be dense sometimes, and yesterday was one of them. I wasn’t reading closely enough, it would seem. I changed the column types to DATETIME in MySQL and now Servoy works fine.
So, I guess my question now would be: is there any way to do just a pure DATE (without the time information) in Servoy, or does it always have to be a DATETIME? It would appear there is no option for this in Dataproviders, but I’d really like to avoid the extra 5 bytes per date field per record if possible.