Dropdown List Format

General Discussion
1

I am using a dropdown list that is populated by a date/time column from a table.
“SELECT DISTINCT Shipment_Date for Holds”
Returns a list in the following format ‘2013-01-01 00:00:00’

I only want to display ‘2013-01-01’ in list drop down list.

I have not been able to figure a way to format the selected date or the dates displayed in the list.

2

If you’re using MySQL use the DATE_FORMAT() function:SELECT DISTINCT DATE_FORMAT(Shipment_Date, '%Y-%m-%d') AS Date from HoldsYou can find out more here.