WeekOfYear ( Date) is not giving correct results.
This link will display the correct weeks of the year: http://www.epochconverter.com/date-and-time/weeknumbers-by-year.php
|Week number||From Date||To Date|
|Week 53, 2015||December 28, 2015||January 3, 2016|
|Week 01||January 4, 2016||January 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.