bb
|
| Posted: 01/26/2005, 11:14 AM |
|
I'd like to have a listbox that allows one to select dates from a MySQL table. Anyone know how to properly format the "bound column" and the "text column"? The table column is a "date" type. I'd like the "text column" displayed for selection in the listbox to be formatted similar to: May 1, 2005
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 01/26/2005, 11:20 AM |
|
As the datasource of your listbox you can use something like:
SELECT record_id, DATE_FORMAT(some_date, '%m/%d/%Y') AS some_date FROM ...
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
bb
|
| Posted: 01/26/2005, 1:21 PM |
|
thx
|
|
|
|
|
