We have an employee that is reluctant or doesn't want to use the mouse drop down menu so her dates are always different making searches difficult (she manually enters rather than clicking with mouse). On those fields that are not drop down calendar style it is easy to right click->date format and set my preference (aka override hers) but when there is a drop down format it doesn't give the option when right clicking.

I need two things:

1. To be able to autoformat the fields with drop down calendar when she manually enters the date as 6/22/07 instead of 06/22/07 as autoentered by dropdown.

2. To autoformat all the old entries that she has done in the past to the dd/mm/yy convention.

Help!!!

You could set your date field to auto-enter (replace existing) the following calculation:

GetAsDate ( Datefield )

This will normalize all entries to the date format set for the file (or the current OS - see File Options > Text).

Existing entries can be fixed by replacing the field contents with itself. Make sure you have a backup before you try that, because it's not undoable.