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}
codeguru.com
Copyright WebMediaBrands Inc., All Rights Reserved.