Click to See Complete Forum and Search --> : Need to select between 2 dates


BinaryAnge
March 15th, 2004, 02:05 PM
I need to create a report for a time period. The dates of the transactions are in the db. How do i tell crystal reports to select the records between 2 dates. I created 2 parameter fields "from" and "to"; how do i add them to the select statement that the viewer uses?

James Longstreet
March 16th, 2004, 03:27 PM
you can add it to your record selection critera in the report;

IF DateField > ?ParamName and DateField <= ?ParamName, or some hybrid of that.

harmonycitra
March 16th, 2004, 04:19 PM
U can also use the folg. code in your record selection formula

{Datafld} in {?from} to {!to}