hugonr
Posts: 17
|
| Posted: 04/26/2005, 8:39 AM |
|
i have one text box configured like this:
name : start_date
caption : start date
type from: database column
type of data: text (i tried date too)
the rest is blank
when i open one record from the grid, if the data type is text appears the date i want but in the format "june, 18 2005...", if i put the data type with date i receive one blank text box....
i tried to change the date format in the project configuration and nothing, i dont know why i get this problem... i get the same problem in the grid, i needed to take the date in hidden text box and convert it in one visible label in the before show like this:
$form->label1->value = date("d/m/Y", strtotime($form->textfield->value));
can anyone help me? (im using mssql connection)
thanks
|
 |
 |
Nicole
Posts: 586
|
| Posted: 04/27/2005, 1:15 AM |
|
Hello,
to display date value in PHP you should fill Database Date Format property in database Connection dialog/Server tab with format that exactly matches the one returned from the database.
E.g. yyyy-mm-dd HH:nn:ss is accepted for MySQL.
_________________
Regards,
Nicole |
|
|
|
hugonr
Posts: 17
|
| Posted: 04/27/2005, 11:00 AM |
|
big thanks!!!!!
|
|
|
|
|
