Re: Pass variable to Oracle Query form Crystal Reports

Wayne Baswell wrote:

> I want to pass a date variable to a sql statement from Crystal
> Reports. The part of the query accepting the variables looks like:
>
> "Calendar_Date between To_Date('1-JUN-03','mm/dd/yy') and
> To_Date('30-JUN-03','mm/dd/yy')"
>
> And I'd be wanting to replace the date part of the query with a
> user-entered date. As I'm new to Oracle and Crystal, I don't know
> where to start. Is there a way to replace the '1-JUN-03' part with a
> variable in Oracle, then modify that variable when I'm designing the
> report?
>
> Grabbing all the results and then filtering them in Crystal won't work
> as this table is very large. Apologies in advance if this question
> has been asked a million times.
>
> --Wayne

Your statement will not work - the date format differs too much from the date offered - result will be an ORA-1860 (iirc) '1-JUN-03','dd-mon-yy', or: '7/1/03','mm/dd/yy'

-- 
Regards, Frank van Bortel