AnsweredAssumed Answered

Date formatting issue

Question asked by nolak37 on Nov 18, 2014
Latest reply on Nov 25, 2014 by philmodjunk


Date formatting issue


Hi all,

I am having a small issue with a file I created using Filemaker Adv.13 and served on server 13 latest update.

The file contains many date fields and is used via web direct by users in Mexico, I went in layout mode and changed the formatting on the fields to custom set as dd/mm/yy. 

The issue is that once the user attempts to enter the date they receive a message stating the format must be mm/dd/yy, and it will not accept the custom format however once the user puts in the date in the mm/dd/yy format, or if the user selects the date from a drop-down calendar once the field has been exited the format shown is dd/mm/yy (the custom formatting), upon entering the field again though it reverts back to mm/dd/yy.

Has anyone else had this issue or can someone help resolve it