I have a FileMaker database that is formatted as dd/mm/yyyy as default. Any New date field I put on a layout, I have to format each one to mm/dd/yyyy. This is a pain in the butt! Any computer I try it on, it dose the same thing. How do I fix this problem?

Any New date field I put on a layout, I have to format each one to mm/dd/yyyy.

 

That's not a solution, because the entry to the field must still follow the d/m/y format being used by the file.

 

Either set the file (in File > File Options > Text) to 'Always use current system settings' or - preferably - save a copy of the file as clone (no records), open it on a computer set to use the m/d/y date format, and import your records.

Automatic message

This topic has been moved from "FileMaker Pro 11" to "Layouts".

 

The General topic areas are intended for the discussion of the functions, features and tools that were new with the particular version mentioned.

All how-to question should be posted to a topic area that best matches the sprit of the question. Many questions can fit into more then one topic area, but you only need to pick one, and go with it.

If you have any questions about this action, please contact me through a private message.

Lee