WeekOfYear ( Date) Function Not working correctly

Discussion created by User22597 on Jan 19, 2016
Latest reply on Jan 20, 2016 by Benjamin Fehr

WeekOfYear ( Date) is not giving correct results.


This link will display the correct weeks of the year:

Week numberFrom DateTo Date
Week 53, 2015December 28, 2015January 3, 2016
Week 01January 4, 2016January 10, 2016


Filemaker is giving a result for the 1st, 2nd and 3rd of Jan as week 1.

Filemaker is recognizing week 2 from the 4th of Jan until the 10th of Jan.


Week 2 is actually from the 11th of Jan until the 17th of Jan.


Is it possible to correct this urgently? All my calculation are giving the incorrect results.