<div>
Is there a reason you are pulling all the data rather than just the ones you want to display?<br />
<br />
Try this<br />
Selection formula<br />
DateTime(Date({Datefield})<wbr />, Time({TimeField})) &gt;= CurrentDateTime - 1<br />
<br />
Suppression formula<br />
DateTime(Date({Datefield})<wbr />, Time({TimeField})) &lt;&nbsp; CurrentDateTime - 1<br />
<br />
If that doesn't work post the error message and show what type the date and time fields are.<br />
<br />
mlmcc
</div>


Is there a reason you are pulling all the data rather than just the ones you want to display?

Try this
Selection formula
DateTime(Date({Datefield}), Time({TimeField})) >= CurrentDateTime - 1

Suppression formula
DateTime(Date({Datefield}), Time({TimeField})) <  CurrentDateTime - 1

If that doesn't work post the error message and show what type the date and time fields are.

mlmcc

<div>
In the Suppression formula:<br />
DateTime(Date({FT_PriceQuo<wbr />teWrk.D040<wbr />_RateEffDa<wbr />te}), Time({FT_PriceQuoteWrk.D04<wbr />0_RateEffT<wbr />ime})) &lt;&nbsp;CurrentDateTime -1<br />
<br />
The error is on the RateEffDate - A date-time is required here. <br />
<br />
All the data is in the Table I'm using by default. &nbsp;So I need to filter on the report. <br />
<br />
Thank you.
</div>


In the Suppression formula:
DateTime(Date({FT_PriceQuoteWrk.D040_RateEffDate}), Time({FT_PriceQuoteWrk.D040_RateEffTime})) < CurrentDateTime -1

The error is on the RateEffDate - A date-time is required here.

All the data is in the Table I'm using by default.  So I need to filter on the report.

Thank you.

<div>
I forgot to mention the fields types - the Date field is an actual Date type and the Time is a string. <br />
<br />
Thanks.
</div>


I forgot to mention the fields types - the Date field is an actual Date type and the Time is a string.

Thanks.

<div>
Thank you - that did the trick.
</div>


<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
I have a report that pulls pricing by date and time - I need to suppress any Lines with Pricing when the download is over 24 hours old. &nbsp;The Date and time fields are separate fields on the report. &nbsp;The details are all in the details a section of the report. <br />
<br />
Thanks in advance!
</div>
</div>


Hello:

I have a report that pulls pricing by date and time - I need to suppress any Lines with Pricing when the download is over 24 hours old.  The Date and time fields are separate fields on the report.  The details are all in the details a section of the report. 

Thanks in advance!

Crystal Reports - Compare Date Time with Current Date and Time

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.