MYSQL date in views not working I am connecting views to an external database and everything works fine if my views handler is a string but not as a date, here is my view definition:

$data['Punches']['Punch_Date'] = array(
   'title' =&gt; t('Punch Date'),
    'help' =&gt; t('Employees Punch Date'),
    'field' =&gt; array(
      'handler' =&gt; 'views_handler_field_date',
      'click sortable' =&gt; TRUE,
    ),
    'sort' =&gt; array(
      'handler' =&gt; 'views_handler_sort_date',
    ),
    'filter' =&gt; array(
      'handler' =&gt; 'views_handler_filter_date',
    ),
    'argument' =&gt; array(
      'handler' =&gt; 'views_handler_argument_date',
    ),
  );


If I change views_handler_field_date to views_handler_field I can see the records in my view. The date coming from mysql looks like

2013-08-27


I would also like to format that date to look like

08-27-2013


The biggest problem is that I want to be able to filter between dates, thanks for any help that can be given.
To set the date format used when dates are displayed on your site, navigate to Home » Administration » Configuration » Regional and language, and set date format.