Letting Users Choose Dates for Records Selection

[Shewolf925]

I'm attempting to build a report in Crystal 11 wherein the system asks user for a beginning and ending date so that they can limit the results they get to only those records within a certain date range.

In the old access database this was done by using the BETWEEN function in a query. However, when I try and do it in Crystal with a parameter it gives me an error when I try and run the query.

The field I'm querying on is in the DATE/TIME format, rather than just a date.

Any and all help is greatly appreciated.

 

[elsenorjose]

Create two date parameters, FromDate and ToDate. Then in your record selection use:

date({Table.Date}) >= {?FromDate} and date({Table.Date}) <= {?ToDate}

This should work.

 

[lbass]

You could use either:

{table.datetime} in {?start} to {?end}

Or,

{table.datetime} >= {?start} and
{table.datetime} < {?end} + 1

-LB