I'd like to have the auto enter feature add a "/" character when entering into a date field automatically. Typing "0322" would become "03/22" and then FileMaker would add the year as it normally does. I am keying hundreds of records a day and I am looking to make it more efficient. Reaching for the "/" key is slowing me down. I tried

Case ( PatternCount ( GetAsText( date worked ); "/" ) = 0; Replace ( GetAsText ( date worked ); 3; 0; "/"); date worked)

but that didn't work. I was surprised that this did not work. What can I do?

Hi

FileMaker validates a date before evaluating an AutoEnter calculation.

So you can't place a calc to transform a string like that into a real date.

But it's possible if you use a text field.

I use the auto enter technique on time fields substituting "." with ":" and "+" with "PM" and this works fine. I was hoping for a similiar experience with the date field. I'll give your suggestion a try!

Note that this will not reverse the order, but skip validation altogether (somewhat similar to entering a date in a custom dialog). You might want to validate the text field by a calculation.