AnsweredAssumed Answered

FileMaker 10 Date Formating Error

Question asked by StephMel on Feb 17, 2009
Latest reply on Feb 18, 2009 by StephMel


FileMaker 10 Date Formating Error

Description of the issue

 FileMaker Product(s) involved:FileMaker Pro 10Operating System(s) involved:Mac 10.5.5Detailed description of the issue:OS Date Formating error Exact steps to reproduce the issue:With FileMaker 10, in the section "File Option" of the menu "File", on the tab "Text", when you activate the option to always use the OS formating, FileMaker apply the OS date format to the date raw data in the file. This option is vital to conform the dates format and to avoid any confusion. FileMaker 10 omits this parameter when it carries out the function script “Insert calculation result”. Consequently, if one uses this function to insert a range of dates coming from a calculation carried out on headings dates whose their creation go back to FM7, the range of dates inserted by this calculation will have the format of date of origination of database instead of the OS date and will cause an error of execution of script. Expected Result:The OS format should apply to dates fields included in an insert calculation result script Actual Result:Bad date format File:I have a demo file of this bug.