I recently migrated one of my Database from Microsoft Access to SQL Server 2005 Express. However, the Dates did not display at all in my PHP Forms.
To ensure that SQL Server “Datetime” is displayed correctly, check the following settings within your CodeCharge Studio Project:
Project => Settings => Locales & Encoding: “Date Display Format” = “dd/mm/yyyy”
In practice, you can set the “Date Display format” (above) to anything you like. It is the default format that is used when the date format is not explicitly set on the control itself.
Project => Settings => Connections => <Connection Name> => Server: Date Format = “yyyy-mm-dd HH:nn:ss.S”
The “Text Box” Properties on each Form within the Project: Date Type = “Date”; Format = “mm/dd/yyyy”; DBFormat = “yyyy-mm-dd HH:nn:ss.S”