Between two dates

[CPglass]

Hi

I am using Crystal 8.5
I have a created date field. I am tying to select between 2 dates from this field. i have created parameter fields called date 1 and date 2. When I go to select expert, click New and then select the created field and then between, I dont get the option to choose the ?date 1 and ?date 2 parameters.

I looked at the formula and I get this

{Sales_Order_Lines_List.Line Status} <> "Cancelled" and
{SALES_ORDERS.created} in Date (0, 0, 0) to Date (0, 0, 0)

How can I change the formula so it will use my parameters and ask me for the two dates please? I have tried all sorts

Thanks

 

[briangriffin]

If you create a parameter, then go into the Select Expert and that parameter is not at the top of the list, then you most likely have a data type mismatch between the parameter field and the database field you're trying to link it to.

So I'm guessing that the parameter is defined as a date and the database field is a datetime, or the other way around.

 

[CPglass]

Hi

I finally got it working, deleted the parameters and added them back in just the same way and it works now and I see the parameterd in the select expert, crazy. Thanks for the reply