WebStudioSC
Posts: 7
|
| Posted: 01/18/2012, 8:46 PM |
|
I'm having trouble getting my Date Column, form MySql, to display in grid. If i change the data type to 'text' it shows but it doesn't take my format (m/d/yyyy). I have tried all the solutions that have been posted, but nothing seems to work.
Has anyone had this issue before?
Please help if you can.
Thanks....
|
 |
 |
Gena
Posts: 591
|
| Posted: 01/18/2012, 11:11 PM |
|
check if you have set correctly DBFormat property DBFormat property (both for the Label and in Global connection properties)
_________________
Gena |
|
|
|
clahti2
Posts: 107
|
| Posted: 02/15/2012, 10:25 PM |
|
more specifically for MySQL:
Data Type: Date
Format: GeneralDate (or whatever you want to display, this is what the user sees in the grid)
DBFormat: yyyy-mm-dd HH:nn:ss
Hope this helps
|
|
|
|
clahti2
Posts: 107
|
| Posted: 02/15/2012, 10:26 PM |
|
more specifically for MySQL, assuming your data type is a datetime field:
Data Type: Date
Format: GeneralDate (or whatever you want to display, this is what the user sees in the grid)
DBFormat: yyyy-mm-dd HH:nn:ss
Hope this helps
|
|
|
|
|
