BF
|
Posted: 11/19/2003, 1:30 PM |
|
Column type in MySQL DB is DATE, Data Type in CCS2 is Date, Format in CCS2 is ShortDate. Every form I use has a date, at least "entrydate". I set the default value on each form to CurrentDate. When form is submitted all fields update database except any of my dates. Doesn't matter if I type them in, or datepick them or set them as defaults. I don't get it. Is it a MySQL setting??Suggestions?
|
|
|
Steve Ebbrell
|
Posted: 11/19/2003, 1:52 PM |
|
Check the CCS Connections DATE FORMAT property, this is the format that the database stores on disk, for MySQL it should be one of the yyyy-mm-dd format options. All your forms and project settings should be the date format you want users to see, ccs will then convert them to and from the MySQL required yyyy-mm-dd format automatically.
|
|
|
|