<div>
What mlmcc said, but you use MM in the format string for months (with a leading 0). &nbsp;mm is for minutes. &nbsp;You can look up CStr in the CR Help to see the different format string options.<br />
<br />
&nbsp;James
</div>


What mlmcc said, but you use MM in the format string for months (with a leading 0).  mm is for minutes.  You can look up CStr in the CR Help to see the different format string options.

 James

<div>
Loaded and tested - the time stamp is gone but the date is messed up.<br />
<br />
What should be: 12/01/1988 is showing on print out as: 00/01/1988
</div>


Loaded and tested - the time stamp is gone but the date is messed up.

What should be: 12/01/1988 is showing on print out as: 00/01/1988

<div>
<div class="content wysiwyg-content">
How can I remove the time component from the date? I have tried several things and unable to remove the time. Current output, for example is showing as: '12/1/1988 12:00:00AM'<br />
<br />
Current Crystal Formula:<br />
<br />
if cdate({rpPatProfile.DateEn<wbr />teredUS}) = cdate(&quot;01/01/1800&quot;) then &quot;&quot;&nbsp;else cstr({rpPatProfile.DateEnt<wbr />eredUS})
</div>
</div>


How can I remove the time component from the date? I have tried several things and unable to remove the time. Current output, for example is showing as: '12/1/1988 12:00:00AM'

Current Crystal Formula:

if cdate({rpPatProfile.DateEnteredUS}) = cdate("01/01/1800") then "" else cstr({rpPatProfile.DateEnteredUS})

Help with a Crystal Report Formula - remove 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.