Amend Week Start and Year Start

[cpiocpio]

Hi

I am trying to sort out a Master Calendar, but have a need for amending the week start day to SUNDAY and the Year Start to June.

In fact the Year Start are as follows, of course Week Number has to start on the June date as well, commencing on Sundays.

dd/mm/yyyy

03/06/2012

02/06/2013

01/06/2014

I have tried using AddMonths(date,6,0) to the week function but it does not return for example the correct week numbers

Mike

[#2]

Possible to upload a sample file

Thanks

AJ

[cpiocpio]

As requested here ia smaple, all the details are within the QVW

[cpiocpio]

Think there is a typo in my file, here is updated inline, i had a FInYear value incorrect for 04/06/2014

* INLINE [
    CalDueDate, i_lifts, FinYear, Country
    01/01/2011, 2,2010/11, UK
    02/01/2011, 2,2010/11,GMBH
    06/01/2012, 2,2011/12,UK
    08/01/2012, 2,2011/12,UK
    02/06/2013, 5,2011/12,UK
    03/06/2012, 2,2012/13,UK
    05/02/2014, 3,2013/14,UK
    10/02/2014, 7,2013/14,UK
    12/02/2014, 2,2013/14,GMBH
    13/02/2014, 1,2013/14,GMBH
    13/02/2014, 1,2013/14,GMBH  
    01/06/2014, 4,2013/14,UK
    04/06/2014, 2,2014/15,GMBH
];

[Gysbert_Wassenaar]

See this blog post: Redefining the Week Start

And this blog post: Redefining the Week Numbers

[cpiocpio]

I attach another version, hipefully have got all the date right this time, not that it would made any difference to the question, but now the numbers add up correctly

[cpiocpio]

Hi

Thanks for pointers

this blog post Redefining the Week Start

Did assit me to amend Week Start and WeekEdn to Sunday and Saturday

But this blog post:

Redefining the Week Numbers

did not get me where I want to be, I think because I also need to ask another question : How to change YEAR START and therefore change the Week Numbering

Basically here are the year start and week numbering starts on these dates: (as per orgonal post)

Commencing on Sundays, the year starts need to be.

dd/mm/yyyy

03/06/2012

02/06/2013

01/06/2014

[MK_QSL]

Please check enclosed file..

Use fMonth as Finance Month (i.e. Start Month of Year)