Radar
Posts: 1
|
| Posted: 11/17/2008, 9:13 AM |
|
Scenario:
MS Access 2007 Database with Short Date Field (MM/DD/YYYY)
CodeCharge 4.1.00.027
PHP 5.2.6
IE 7.0.6001.18000
I have an insert/update form that retrieves values from my MS Access database - all fields are fine except the date fields which show up blank. The date fields are set as text fields with DataType set to Date and with DBFormat set to MM/DD/YYYY. If I use the associated Date Picker or manually enter data and save the record, the database will have the updated date but it show up blank on the form when you edit the record.
If I change the field to DataType to text only - I get the value from the MS Access database but it is in the wrong format (Date + Time instead of just DATE).
Any assistance would be appreciated. Thanks, Radar
|
 |
 |
|
