<div>
According to According to ISO 8601 the week starts on Monday, so the formula should be:<br />
<br />
DatePart(&quot;ww&quot;,{Table.DateF<wbr />ield},crMo<wbr />nday,crFir<wbr />stFourDays<wbr />)<br />
<br />
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 !!<br />
<br />
To workaround this bug use the formula:<br />
<br />
IIF( DatePart(&quot;ww&quot;,{Table.DateF<wbr />ield},crMo<wbr />nday,crFir<wbr />stFourDays<wbr />) &gt;&nbsp;53, 53, &nbsp; DatePart(&quot;ww&quot;,{Table.DateF<wbr />ield},crMo<wbr />nday,crFir<wbr />stFourDays<wbr />))<br />

</div>


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))


<div>
<div class="content wysiwyg-content">
I need to calculate the week number that we are currently in for a crystal report from a given date.
</div>
</div>


I need to calculate the week number that we are currently in for a crystal report from a given date.

Week number in Crystal reports

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.