<div>
Use the SELECT EXPERT<br />
<br />
{DateField} &gt;= DateAdd('yyyy'-5,CurrentDa<wbr />te)<br />
<br />
mlmcc
</div>


Use the SELECT EXPERT

{DateField} >= DateAdd('yyyy'-5,CurrentDate)

mlmcc

<div>
Thanks...<br />
I used the following formula:<br />
{CASE.FILE_DT} &gt;= DateAdd('2010'-5,CurrentDa<wbr />te)<br />
and I get the error message that &quot;A number, currency amount, date, time, or date-time is required here.&quot;
</div>


Thanks...
I used the following formula:
{CASE.FILE_DT} >= DateAdd('2010'-5,CurrentDate)
and I get the error message that "A number, currency amount, date, time, or date-time is required here."

<div>
Where do you get that?<br />
<br />
You have to add that to the selection filter <br />
REPORT --&gt; SELECT EXPERT<br />
<br />
mlmcc
</div>


Where do you get that?

You have to add that to the selection filter
REPORT --> SELECT EXPERT

mlmcc

<div>
Yes, I did add it to the select expert and that's the error that comes up
</div>


Yes, I did add it to the select expert and that's the error that comes up

<div>
i see the issue.<br />
<br />
Don't use 2010 use yyyy<br />
You are telling dateadd to add years<br />
<br />
mlmcc
</div>


i see the issue.

Don't use 2010 use yyyy
You are telling dateadd to add years

mlmcc

<div>
Thank you. This works perfectly.
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
Is there a way to create a date formula that will pull records from the current date back 5 years? &nbsp;The formula should look at a date time field on the report and retrieve records that go back 5 years from the current date. The report is querying an Oracle database. Any suggestions? &nbsp;Thanks. 
</div>
</div>


Hello Experts,
Is there a way to create a date formula that will pull records from the current date back 5 years?  The formula should look at a date time field on the report and retrieve records that go back 5 years from the current date. The report is querying an Oracle database. Any suggestions?  Thanks. 

Date formula that goes back 5 years

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.