Thank you Allan, That answers my confusion definitely.
Best Regards, Agus On Thu, Jul 29, 2010 at 11:20 PM, allanwallis <all...@raven-computers.co.uk>wrote: > > > > The AX documentation states that the WkofYr function calculates the week of > the year in which a date is located according to the ISO 8601 specification. > > > The ISO standard states:- > The first week of the year is defined as beginning on the Monday of the > week in which the first Thursday of January occurs. > > So 01/01/2010 ( a friday ) is week 53, i.e. the end of the last week of the > previous year. It isn't a bug, it is working correctly. > > > --- In > Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.com>, > Agus Riyadi <agusa...@...> wrote: > > > > 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 > > > > >