<div>
You can just put it all together like this: 
DATE(Left({V_My_Portfolio_1.Manager Date From}, 4), 
Mid({V_My_Portfolio_1.Manager Date From}, 5,2), Right({V_My_Portfolio_1.Manager Date From}, 2))
</div>

You can just put it all together like this:
DATE(Left({V_My_Portfolio_1.Manager Date From}, 4),
Mid({V_My_Portfolio_1.Manager Date From}, 5,2), Right({V_My_Portfolio_1.Manager Date From}, 2))

<div>
<div class="content wysiwyg-content">
I have a field which is of type string and looks like: &nbsp; 20080115 (ie YYYY-mm-dd) 
 
Is there an easier way to convert it to type date than the following formula? 
 
 
Local StringVar DaypartTemp; 
Local StringVar MonthpartTemp; 
Local StringVar YearpartTemp; 
Local NumberVar Daypart ; 
Local NumberVar MonthPart; 
Local NumberVar YearPart ; 
 
DayParttemp := Right({V_My_Portfolio_1.Manager Date From}, 2); 
MonthParttemp := Mid({V_My_Portfolio_1.Manager Date From}, 5,2); 
YearParttemp := Left({V_My_Portfolio_1.Manager Date From}, 4); 
 
Daypart := ToNumber(DaypartTemp); 
MonthPart := ToNumber(MonthpartTemp); 
YearPart := ToNumber(YearpartTemp); 
 
Date (YearPart,MonthPart,DayPart ) 
 
 
 

</div>
</div>

I have a field which is of type string and looks like:   20080115 (ie YYYY-mm-dd)

Is there an easier way to convert it to type date than the following formula?


Local StringVar DaypartTemp;
Local StringVar MonthpartTemp;
Local StringVar YearpartTemp;
Local NumberVar Daypart ;
Local NumberVar MonthPart;
Local NumberVar YearPart ;

DayParttemp := Right({V_My_Portfolio_1.Manager Date From}, 2);
MonthParttemp := Mid({V_My_Portfolio_1.Manager Date From}, 5,2);
YearParttemp := Left({V_My_Portfolio_1.Manager Date From}, 4);

Daypart := ToNumber(DaypartTemp);
MonthPart := ToNumber(MonthpartTemp);
YearPart := ToNumber(YearpartTemp);

Date (YearPart,MonthPart,DayPart )





How to convert a text field to date in crystal reports

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.