Thanks Steen for your reply. That site explains that 6th of Jan may be in different week depends on the year (which may fall between 1 or 2). It does make sense. But that does not explain why 1 Jan 2010 get week of year = 53.
Best regards, Agus On Thu, Jul 29, 2010 at 3:25 PM, Steen Rabol <sra...@mail.tele.dk> wrote: > > > http://msdn.microsoft.com/en-us/library/aa890352.aspx > > > > 2010/7/29 Agus Riyadi <agusa...@gmail.com> > > >> >> Dear All, >> >> Using Ax built-in function WkOfYr I get the following result : >> >> 1 Jan 2005 => 53 1 Jan 2006 => 52 1 Jan 2007 => 1 1 Jan 2008 => 1 1 >> Jan 2009 => 1 1 Jan 2010 => 53 1 Jan 2011 => 52 1 Jan 2012 => 52 1 Jan 2013 >> => 1 1 Jan 2014 => 1 1 Jan 2015 => 1 1 Jan 2016 => 53 1 Jan 2017 => 52 1 >> Jan 2018 => 1 1 Jan 2019 => 1 1 Jan 2020 => 1 >> >> I thought it should always returns 1. Is there any fix on this ? >> >> Thanks and best regards, >> >> Agus >> >> > > > -- > Med venlig hilsen / Kind regards > Steen Rabøl > > LUX Mobil: +352 621 304 484 > > >