<div>
fomat field -&gt; custum style: customise : Date Tab and change seperators
</div>


fomat field -> custum style: customise : Date Tab and change seperators

<div>
Sorry but that won't work as this is a TEXT field containing this date. &nbsp;that's what I meant by STRING field.<br />

</div>


Sorry but that won't work as this is a TEXT field containing this date.  that's what I meant by STRING field.


<div>
so make a formula and use the functions right and left to manage this issue
</div>


so make a formula and use the functions right and left to manage this issue

<div>
I need specific details and syntax how-to. &nbsp;thank you
</div>


I need specific details and syntax how-to.  thank you

<div>
create a formula:<br />
left(x,2) +&quot;/&quot; + Mid (x, 2,2 )Right (x,2 )<br />
where x is the value you are managing
</div>


create a formula:
left(x,2) +"/" + Mid (x, 2,2 )Right (x,2 )
where x is the value you are managing

<div>
 If this is related to your previous question about pulling the dates out of a string and reformatting them (and assuming that you don't need the dates in both MM/DD/YY _and_ MM-DD-YY format), then you could just replace the &quot;-&quot;s in your formula with &quot;/&quot;s. &nbsp;For example, change<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; displayField3 := DateParts[1] &amp;&nbsp;'-' &amp;&nbsp;DateParts[2] &amp;&nbsp;'-' &amp;&nbsp;Right(DateParts[3],2)<br />
&nbsp; to<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; displayField3 := DateParts[1] &amp;&nbsp;'/' &amp;&nbsp;DateParts[2] &amp;&nbsp;'/' &amp;&nbsp;Right(DateParts[3],2)<br />
<br />
<br />
&nbsp;James<br />

</div>


If this is related to your previous question about pulling the dates out of a string and reformatting them (and assuming that you don't need the dates in both MM/DD/YY _and_ MM-DD-YY format), then you could just replace the "-"s in your formula with "/"s.  For example, change

          displayField3 := DateParts[1] & '-' & DateParts[2] & '-' & Right(DateParts[3],2)
  to
          displayField3 := DateParts[1] & '/' & DateParts[2] & '/' & Right(DateParts[3],2)


 James


<div>
Simple and effective. &nbsp;thank you
</div>


<div>
<div class="content wysiwyg-content">
Hopefully this is an easy question. &nbsp;I have a string field which contains a date field. &nbsp;The date is formatted as MM-DD-YY and I wish to change that to MM/DD/YY. &nbsp;How can I do this?<br />
thanks
</div>
</div>


Hopefully this is an easy question.  I have a string field which contains a date field.  The date is formatted as MM-DD-YY and I wish to change that to MM/DD/YY.  How can I do this?
thanks

Crystal Report - Chnage date field separators

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.