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