GeorgeS
Posts: 206
|
| Posted: 01/16/2008, 1:14 PM |
|
Hi,
Project Settings - Locales & Encodings - Date Display format
set to: ShortDate
MySql field type: date
Text box with pop-up calendar in Editable Grid -
Data Type: Date,
Format: ShortDate
All inserted / updated through the editable grid dates are showing up as 0000-00-00 in MySql
-------------------------------------------------------------------------------------------
What else should I set up and where?
Thank you
_________________
GeorgeS |
 |
 |
ckroon
Posts: 869
|
| Posted: 01/16/2008, 2:08 PM |
|
Look for the dbformat box at the bottom of the Properties-Data tab
it should be set to yyyy-mm-dd
_________________
Walter Kempees...you are dearly missed. |
 |
 |
GeorgeS
Posts: 206
|
| Posted: 01/16/2008, 3:31 PM |
|
Thanks!
I knew that I forgot something...
_________________
GeorgeS |
 |
 |
|