AnsweredAssumed Answered

Calendar functions goes bananas for Swedish locale

Question asked by Martin Norén on Dec 12, 2014
Latest reply on Dec 12, 2014 by Martin Norén


Calendar functions goes bananas for Swedish locale


FileMaker Pro



Operating system version

Mac OS X 10.9.5

Description of the issue

DayName ( 2014-12-12 ) returns "tisdag" (Tuesday)
Day ( 2014-12-12 ) returns "13"
DayOfWeek ( 2014-12-12 ) returns "3" (Equals Tuesday)

Steps to reproduce the problem

Use the Day-functions with Swedish locale

Expected result

DayName ( 2014-12-12 ) should be Friday
Day ( 2014-12-12 ) should return "12"
DayOfWeek ( 2014-12-12 ) should return "6"

Actual result

Described above

Exact text of any error message(s) that appear

No errors - just wrong result

Configuration information

Tested on Mac OS X FileMaker Pro Advanced 12.0v5 and 13.0v4
and Windows 8.1 FileMaker Pro Advanced 13.0v3