emorales
|
| Posted: 02/07/2003, 11:53 AM |
|
Hello!
i have a problem, i`m doing an aplication in CCS with PHP and MySql, the problem is when insert a row, i need the date of the transaction, in a text box i set the default date in format yyyy/mm/dd , the row is saved, but in the data base (My SQL) the colum Date is empty.
emorales
|
|
|
 |
masster
|
| Posted: 02/08/2003, 4:52 PM |
|
Solution 1:
Make the transaction date hidden and in the Properties put this:
Source Type: Database Column (obviously, you need data to go there)
Control Source: name of the field
Data type: Date
Default: CurrentDate (if you need only the date)
DBFormat: yyyy-mm-dd (select first the yyyy-mm-dd HH:nn:ss option and delete what you don't need. If only this would have been written in the manual...)
Solution 2:
If you need to insert the transaction date by hand in a textbox, you need to add to the above properties the Format: (mm/dd/yyyy for instance if you need the american date) for the right input. I know, the status bar in the Properties windows sucks. It raises more questions than answers...
Now, all will go smoothly.
|
|
|
|
|
