<div>
Question(s) -<br />
Why does your parameter have to be a string? &nbsp; &nbsp;<br />
Why not use a date if you are comparing it to a date?<br />
What other entry would you expect a user to input if it is not a date?<br />
<br />
This can certainly be done, but it doesn't seem to make too much sense from the information you've provided?
</div>


<div>
The other selections on the parameter are strings like &quot;Todays Date&quot; and &quot;None&quot;. I will end up using 3 parameters with this report but only 1 will be used for record selection. I am having to jump thru some hoops here to get my boss what he wants.
</div>


<div>
So you have 1 parameter with values like &quot;Todays Date&quot; or &quot;None&quot; or they can enter a date in YYMMDD format?
</div>


<div>
Deb,<br />
<br />
The following code will convert a Parameter to a date. &nbsp;It will default to 1/1/1980 if no date is entered.<br />
<br />
For the purposes of this, I asummed only 20xx dates would be used. &nbsp;<br />
<br />
-Doug<br />
<br />

<pre><code class="code-1 nolinks" id="code-123440"><span>//{@string-to-date}</span>
<span>//For converting a String Parameter in YYMMDD format to a date</span>
<span> </span>
<span>StringVar datein;</span>
<span> </span>
<span>datein := {?MY PARAMETER HERE};</span>
<span> </span>
<span>if Len(datein) &lt;&gt; 6 or not (NumericText(datein)) then Date(1980,1,1) else</span>
<span>Date(ToNumber(Left(datein,2))+2000,ToNumber(Mid(datein,3,2)),ToNumber(Mid(datein,5,2)));</span>
</code></pre>
</div>


<div>
stupid question, <br />
why don't you change the parameter to datetime field to match you data field. <br />
<br />

</div>


<div>
i guess i should have refresh before i post
</div>


<div>
dougvarga, I can see where this would convert my string into a date field formatted in YYMMDD. Do you know how to take a datetime field and do the same thing?
</div>


<div>
Date({mytable.mydatefield}<wbr />)
</div>


<div>
Thanks dougarga. Does it return the date in YYMMDD format? 
</div>


<div>
Once you have the formula to convert the parameter to a date, and if you use that in your record selection formula, you won't need to convert the database datetime field.
</div>


<div>
Thanks dougvarga. I will try it out.
</div>


<div>
<div class="content wysiwyg-content">
I need to know the best way to do this. I have a crystal parameter which needs to be a string. If the user enters a date it will be entered as YYMMDD. In &nbsp;the record select section I need to compare this string to a datetime field to see if the record should be included. I would like to convert these 2 variables to a number field in YYMMDD order. I need to do this using crystal functions and not SQL. Thanks for any assistance.
</div>
</div>


I need to know the best way to do this. I have a crystal parameter which needs to be a string. If the user enters a date it will be entered as YYMMDD. In  the record select section I need to compare this string to a datetime field to see if the record should be included. I would like to convert these 2 variables to a number field in YYMMDD order. I need to do this using crystal functions and not SQL. Thanks for any assistance.

Crystal Reports - compare datetime variable to parameter string

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.