User22597

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: http://www.epochconverter.com/date-and-time/weeknumbers-by-year.php

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.

Outcomes