Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Possible to upload a sample file
Thanks
AJ
As requested here ia smaple, all the details are within the QVW
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
];
See this blog post: Redefining the Week Start
And this blog post: Redefining the Week Numbers
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
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:
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
Please check enclosed file..
Use fMonth as Finance Month (i.e. Start Month of Year)