Skip to Content
0
Former Member
Dec 07, 2006 at 07:36 AM

Convert Test Field to Date Field

31 Views

<p>I am new to Crystal Reports and trying to change a text field that has a date value. The date field is defined as, Date: String [10] and displays as i.e, Mon 11-Nov. I want to setup a paramater field that prompts the user to enter a date range with a start and end date and get the specific records requested. I&#39;ve tried some different options using the Formula Editor but I cannot get the distinct records requested. For example, if I only want records between Mon 06-Nov thru Fri 10-Nov, I&#39;m also getting data for Mon 13-Nov. How can I convert this field to a date field that can be used with a parameter and displays distinct records? I am using Crystal Report XI.</p><p>Thanks,</p>