Why not set it up as a date drop down - a tiny calendar to select date.
Home > Designing and creating databases > Editing objects on layouts > Formatting and setting up field objects in Layout mode > Setting up a field to display a drop-down calendar
Setting up a field to display a drop-down calendar
Curious note - a date field is actually the number of days since Jan 01, 1900 - and can be formatted in a number of ways.
If the user is consistent in the use of two digits for the month and date, the OnObjectValidate script trigger can perform a script to take the data input by the user and replace it with a true date.
Thanks for the answer. I do appreciate that I could add the dropdown calendar, actually is already there, however, the person using the system always adds de date consistently as ddmmyy and I wanted to have the separator to appear automatically.
Phil, thanks for the reply. I'll look into that possibility.
Thank you very much
Works like a charm. Appreciated!