I should have said in the first post that I am NOT a coder, but with some samples I can usually do some coding. I am working in PHP and just need a sample of setting a format up for a date format mm/dd/yyyy. Thank you.
This example uses PHP, which has two extremely useful built-in functions for dealing with dates and times: strtotime() and date().
1 $res = mysql_query('SELECT datefield FROM tablename WHERE foo = "bar"');
2 $row = mysql_fetch_array($res);
3 print date('d M Y', strtotime($row['datefield']));
The strtotime() function is used to parse the date and time returned from the MySQL query into a UNIX timestamp. The date() function then formats that returned timestamp into 'd M Y' format, which is the day of the month with a leading zero, followed by the short month name (eg 'Jan', 'Feb', 'Mar') then a 4 digit year.