<div>
You can find the same week by<br />
<br />
Dateadd (&quot;W&quot;,-52,{SaleDate})<br />
<br />
You can then use that in your if statement.<br />
<br />
good luck<br />
mlmcc
</div>


You can find the same week by

Dateadd ("W",-52,{SaleDate})

You can then use that in your if statement.

good luck
mlmcc

<div>
hi mimcc,<br />
<br />
thx for the quick response but,<br />
<br />
Dateadd does'nt seem to function in formula editor
</div>


hi mimcc,

thx for the quick response but,

Dateadd does'nt seem to function in formula editor

<div>
i have managed to install the DateAdd function as i am using version 7. Only to find another error shows up. This time is states 'A date-time is required here'
</div>


i have managed to install the DateAdd function as i am using version 7. Only to find another error shows up. This time is states 'A date-time is required here'

<div>
mimcc,<br />
<br />
CDate did not work, however DateTime works, and after a couple more hours trying to grab the whole week of last year, i have managed to get it working.... thx a lot for help!<br />
<br />
much appreciated :)<br />
<br />
m0le2000
</div>


mimcc,

CDate did not work, however DateTime works, and after a couple more hours trying to grab the whole week of last year, i have managed to get it working.... thx a lot for help!

much appreciated :)

m0le2000

<div>
<div class="content wysiwyg-content">
I'm running a report which compares results from last week using the LastFullWeek function. However, i would like to compare the same week in last year. I have tried LastFullWeek-52 but without any luck. <br />
<br />
***CURRENTLY***<br />
If {SaleDate} = LastFullWeek<br />
THEN {Transactions}<br />
<br />
***I WOULD LIKE***<br />
If {SaleDate} = LastFullWeek (IN THIS TIME LAST YEAR)<br />
THEN {Transactions}<br />
<br />
<br />
Any help is appreciated :)
</div>
</div>


I'm running a report which compares results from last week using the LastFullWeek function. However, i would like to compare the same week in last year. I have tried LastFullWeek-52 but without any luck. 

***CURRENTLY***
If {SaleDate} = LastFullWeek
THEN {Transactions}

***I WOULD LIKE***
If {SaleDate} = LastFullWeek (IN THIS TIME LAST YEAR)
THEN {Transactions}


Any help is appreciated :)

LastFullWeek from Last year

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.