[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Week numbers for 2010

Posted on 2009-12-23
3
Medium Priority
?
1,348 Views
Last Modified: 2012-05-08
There appears to be an issue with the default week numbers reported by Crystal for 2010.

According to ISO 8601 ( http://en.wikipedia.org/wiki/ISO_8601) week 1 is the week that contains the 4th of January (and equally, the 1st Thursday of the year).

However, when reporting the week number (CR XI or 2008) for 4th January 2010 Crystal says this is week 2 ???

I know I can change this in individual formulae using a format like:

    DatePart("ww",{Table.DateField},crSunday,crFirstFourDays)

rather than
    DatePart("ww",{Table.DateField})

but this would mean I would have to change lots of formulae manually. Is there a way to change the system default?
0
Comment
Question by:ravenblue
3 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 1500 total points
ID: 26115632
0
 
LVL 4

Author Closing Comment

by:ravenblue
ID: 31669405
I feared that was the case. Thanks for your time
0
 

Expert Comment

by:delind
ID: 26476540
According to According to ISO 8601 the week starts on Monday, so the formula should be:

DatePart("ww",{Table.DateField},crMonday,crFirstFourDays)

In CR 11.0.0.1994 (and maybe later versions too) I discoverd a bug in this function for the dates 1-1-2010 until 3-1-2010. The function returns 9652 or 9653 instead of 53 !!

To workaround this bug use the formula:

IIF( DatePart("ww",{Table.DateField},crMonday,crFirstFourDays) > 53, 53,   DatePart("ww",{Table.DateField},crMonday,crFirstFourDays))
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question