Jeff
|
| Posted: 06/29/2002, 9:49 PM |
|
Hello,
CCS using PHP/Templates on W2k w/ MySQL and Apache.
I have a form that I input a date on. It saves to MySQL no problem. But I
can not get it to display on the grid. I have all of my settings
(DB/Project etc) set to the same date format.
Anyone?
Thanks
Jeff
|
|
|
 |
Steve R
|
| Posted: 06/30/2002, 5:41 AM |
|
Hi Jeff,
I too am using W2k with MySQL and Apache and I have no problem displaying
dates and this is how I did it.
1. Click on your database connection in the Project Explorer, on the Data
tab, make the date format here yyyy-mm-dd HH:nn:ss
2. Set up in your Project...Settings what default display format you want
i.e. dd/mm/yyyy or set up date fields independently.
The first step is the critical one as you are defining how it is stored in
MySQL, get this wrong and nothing works.
Good luck,
Steve
"Jeff" <schedin@attbi.com> wrote in message
news:afm2lb$sem$1@news.codecharge.com...
> Hello,
>
> CCS using PHP/Templates on W2k w/ MySQL and Apache.
>
> I have a form that I input a date on. It saves to MySQL no problem. But I
> can not get it to display on the grid. I have all of my settings
> (DB/Project etc) set to the same date format.
>
> Anyone?
>
> Thanks
> Jeff
>
>
|
|
|
|
|
