Maris Kalnins
|
| Posted: 12/11/2002, 3:18 AM |
|
Hi!
Has anybody experienced problem in CCS 1.0.7.0 to output
a date field values from MySql into CCS Grid?
If I change the Data Type of the output label to TEXT - everything works
(but I cannot set the desired output format dd/mm/yyyy for example)
If the Data Type of the output label is set to DATE - it returns empty
string
I had been struggling with this for a while I cannot understand,
does date fields supported at all.. 
Thanks
Maris
|
|
|
 |
RonB
|
| Posted: 12/11/2002, 6:48 AM |
|
The date fields have to be formated in the properties box.
Set Format to (european) dd-mm-yyyy, dont be fooled by the ldrop list you
can just type your own format here.
In the DBFormat type yyyy-mm-dd That should do the trick.
RonB
"Maris Kalnins" <proximus@e-teliamtc.lv> schreef in bericht
news:at76u2$1jr$1@news.codecharge.com...
> Hi!
>
> Has anybody experienced problem in CCS 1.0.7.0 to output
> a date field values from MySql into CCS Grid?
>
> If I change the Data Type of the output label to TEXT - everything works
> (but I cannot set the desired output format dd/mm/yyyy for example)
>
> If the Data Type of the output label is set to DATE - it returns empty
> string
>
> I had been struggling with this for a while I cannot understand,
> does date fields supported at all..
>
> Thanks
> Maris
>
>
|
|
|
|
|
