One very cool thing about php is that you can manipulate dates with the date() and strtotime() functions to get the date formatted the way that you would like it.
Where the value is being inserted you can reformat the value entered by the user to match what the db needs. Then on the results, details or any other page where you display the date you can format it to meet the needs of your locale.
Here is an example of how to format the date the the user has entered. In your insert server behavior you are setting the value of the column to your posted element like this:
$_POST['<your date field>']
You can wrap the strtotime and date functions around this value to reformat it like this:
date("Y-m-d", strtotime($_POST['<your date field>']))
This will reformat the date that the user entered to match what your db needs. Then whenever you want to display the date from the db you would do so like this:
date("d-m-Y", strtotime($row_RSrecordset['the_date']))
If you can post back with a copy of the insert, update and details pages I can show you just where you need to make these edits.
