3 Replies Latest reply: Sep 13, 2011 10:37 AM by qv_ty_mi RSS

    calendar week / year problem

      Dear all,

       

      I am looking for a way to display the correct year according to a calendar week (cw) based on a date.

      Solution has to be ISO 8601 conform.

       

      Current Script:

      week(myDate) & ' / ' & year(myDate)

       

      Example:

      01. Jan 2008 --> 01/2008 --> correct

      01. Jan 2010 --> 52/2010 --> wrong! should be 52/2009!

      31. Dec 2007 --> 01/2007 --> wrong! should be 01/2008!

       

      Any ideas / hints how to solve this?

       

      Many thanks in advance