that can't be done in a real date field because the validation of the date field comes before the auto-enter options of the field.
But can be done in a text field or using two field.
You could do this with a triggered script, if you have version10.
No answer from me, but I'm interested in what the triggered script in version 10 or 11 would be. My user wants to enter mmddyyyy and get mm/dd/yyyy
Gordon in LR
I have not tried this but I able to enter a date in a field as dd/mm/yyyy and for the field to immediately convert it to say: Tuesday, 15 March 2010
So it might be possible to enter the date as ddmmyyyy (as entered) or have the field convert it or another date field set up to convert it. The problem it havin g FM know is a date and in what order to interpret it.
You could set a script to trigger OnObjectModify, for example:
If [ IsEmpty ( Filter ( Get ( ActiveFieldContents ) ; "-" ) )
Length ( Get ( ActiveFieldContents ) ) = 8 ]
Set Field [ Table::Date; Replace ( Replace ( Table::Date ; 5 ; 0 ; "/" ) ; 3 ; 0 ; "/" ) ]