<div>
I am fairly new to Crystal reports how do you use the calender function or make it so they input a text into a mask.
</div>


I am fairly new to Crystal reports how do you use the calender function or make it so they input a text into a mask.

<div>
I was able to figure it out with your suggestion. &nbsp;Thanks for your help.
</div>


I was able to figure it out with your suggestion.  Thanks for your help.

<div>
When you make your parameter field you can set it's data type and you can select datetime . When you do and when you run the report you will be prompted with a datetime control which includes a calendar and time fields. <br />
<br />
Are you decent with SQL? If not, post your table structures and I can help with the command. Also, what kind of database are you using? Oracle? SQL Server? Something else?
</div>


When you make your parameter field you can set it's data type and you can select datetime . When you do and when you run the report you will be prompted with a datetime control which includes a calendar and time fields.

Are you decent with SQL? If not, post your table structures and I can help with the command. Also, what kind of database are you using? Oracle? SQL Server? Something else?

<div>
I got it to work using the date in the parameter but we are using DB2. &nbsp;<br />
<br />
Thanks for the help.<br />
<br />
Montrof
</div>


I got it to work using the date in the parameter but we are using DB2.  

Thanks for the help.

Montrof

<div>
<div class="content wysiwyg-content">
Dates in the database are stored as numbers, such that a date of 12/07/2007 is stored as 20071207 and in crystal shows as 20,071,207. We would like to use a date field in a parameter but want to display as mm/dd/yyyy. &nbsp;We can manipulate the field with a formula field to desired format, but this field is not an allowed option in the value drop down on parameter settings. &nbsp;In essence, can you apply a function to a parameterized value? &nbsp;If not, what is the work around to this? &nbsp;<br />
&nbsp;<br />
<br />

</div>
</div>


Dates in the database are stored as numbers, such that a date of 12/07/2007 is stored as 20071207 and in crystal shows as 20,071,207. We would like to use a date field in a parameter but want to display as mm/dd/yyyy.  We can manipulate the field with a formula field to desired format, but this field is not an allowed option in the value drop down on parameter settings.  In essence, can you apply a function to a parameterized value?  If not, what is the work around to this?  
 



Format data in a Parameter

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.