2 Replies Latest reply on Jan 20, 2016 12:55 AM by Benjamin Fehr

    WeekOfYear ( Date) Function Not working correctly

    User22597

      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.