Chris__T
Posts: 339
|
| Posted: 08/29/2007, 9:14 AM |
|
I must have a brain cloud because I can't seem to figure this out. And I know I've done it before!
A label on my page is showing the date from a mysql database field. Nothing hard there. But it's showing up as 2007-07-10 00:0
I'm was going to use DATE_FORMATE(label, '%c %d %Y') to convert it to looks like 07-10-2007 but I can't figure out where to put it.
|
 |
 |
wkempees
|
| Posted: 08/29/2007, 2:38 PM |
|
click the label, properties set Format the required dateformat??
to"Chris__T" <Chris__T@forum.codecharge> schreef in bericht
news:646d59b7e8852b@news.codecharge.com...
>I must have a brain cloud because I can't seem to figure this out. And I
>know
> I've done it before!
>
> A label on my page is showing the date from a mysql database field.
> Nothing
> hard there. But it's showing up as 2007-07-10 00:0
>
> I'm was going to use DATE_FORMATE(label, '%c %d %Y') to convert it to
> looks
> like 07-10-2007 but I can't figure out where to put it.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Chris__T
Posts: 339
|
| Posted: 08/30/2007, 8:40 AM |
|
Argh! Thanks Walter. I had tried that before, and it was loading up a blank page in the web browser. So I didn't know what was going on. I looked deeper and lo and behold, the field type in the actual database was a varchar, not a date! Doh! Changed it and everything works fine. Thanks.
|
|
|
|
wkempees
|
| Posted: 08/30/2007, 12:18 PM |
|
contrary to the general opinion not all is wrong with CCS, lol.
"Chris__T" <Chris__T@forum.codecharge> schreef in bericht
news:646d6e508a4a99@news.codecharge.com...
> Argh! Thanks Walter. I had tried that before, and it was loading up a
> blank
> page in the web browser. So I didn't know what was going on. I looked
> deeper
> and lo and behold, the field type in the actual database was a varchar,
> not a
> date! Doh! Changed it and everything works fine. Thanks.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Chris__T
Posts: 339
|
| Posted: 08/31/2007, 12:00 PM |
|
LOL...exactly! 
|
|
|
|
|
