<div>
Perhaps.<br />
<br />
totext(CurrentDate, &quot;mm-dd-yy&quot;)
</div>


Perhaps.

totext(CurrentDate, "mm-dd-yy")

<div>
That gives me &quot;mm-dd-yy&quot; in text format.
</div>


<div>
What are you trying to do?<br />
<br />
YOu should be able to simply set a custom format for the field<br />
<br />
Right click the field on the report<br />
Click FORMAT FIELD<br />
Click the DATE tab<br />
Select the format if it is shown or click CUSTOMIZE<br />
Set the format as desired<br />
<br />
mlmcc
</div>


What are you trying to do?

YOu should be able to simply set a custom format for the field

Right click the field on the report
Click FORMAT FIELD
Click the DATE tab
Select the format if it is shown or click CUSTOMIZE
Set the format as desired

mlmcc

<div>
I am putting the field into a formula which is used to create a barcode. The following works: Replace(totext(currentdate<wbr />), &quot;/&quot;, &quot;-&quot;), though it uses &quot;yyyy&quot; instead of &quot;yy&quot;.
</div>


I am putting the field into a formula which is used to create a barcode. The following works: Replace(totext(currentdate), "/", "-"), though it uses "yyyy" instead of "yy".

<div>
Don't you have to specify a format, e.g. mm/dd/yyyy, when using totext?<br />
<br />

<pre><code id="code-20-42454837-1">ToText({table.datefield},&quot;MM/dd/yyyy&quot;)</code></pre>
</div>


Don't you have to specify a format, e.g. mm/dd/yyyy, when using totext?



ToText({table.datefield},"MM/dd/yyyy")

<div>
Making the year from four digits to two digits makes the barcode smaller. Thanks.
</div>


Making the year from four digits to two digits makes the barcode smaller. Thanks.

<div>
<div class="content wysiwyg-content">
In Crystal Reports, I need a formula &nbsp;to change CurrentDate from mm/dd/yyyy to mm-dd-yy without changing Options/Fields/Date.
</div>
</div>


In Crystal Reports, I need a formula  to change CurrentDate from mm/dd/yyyy to mm-dd-yy without changing Options/Fields/Date.

Formula to format date from using  &quot;/&quot; to &quot;-&quot;.

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.

Formula to format date from using &quot;/&quot; to &quot;-&quot;.

Formula to format date from using "/" to "-".