<div>
Convert them to int, then you can convert/cast...... As text..<br />
<br />
The day can be appended... &nbsp;What formatting are you looking for yyyy-month-day?<br />
<br />
Do you have a separate date field that can be used to handle the conversion and assembling the response field on the report?
</div>


Convert them to int, then you can convert/cast...... As text..

The day can be appended...  What formatting are you looking for yyyy-month-day?

Do you have a separate date field that can be used to handle the conversion and assembling the response field on the report?

<div>
thank you, Fast and excellent as always .
</div>


thank you, Fast and excellent as always .

<div>
<div class="content wysiwyg-content">
I have several fields in crystal report 2011, two of them have values for Year and for month and they are number type field.<br />
I need formula to convert this two number fields (Year and month) to date. That converted date should show year month and day. Day has to be the last date of the month.<br />
How to do it?<br />
<br />
Invoice_Year &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Invoice_Month<br />
2,015.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.00<br />
2,014.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.00<br />
2,014.00 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3.00
</div>
</div>


I have several fields in crystal report 2011, two of them have values for Year and for month and they are number type field.
I need formula to convert this two number fields (Year and month) to date. That converted date should show year month and day. Day has to be the last date of the month.
How to do it?

Invoice_Year		Invoice_Month
2,015.00 			1.00
2,014.00			2.00
2,014.00			3.00

Crystal report convert number to date

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.