How do you display values between two dates?

[TomBarrand]

Hi,

I need to use a Crystal report that only displays records that are between a certain date period, e.g. 20/01/2001 - 19/02/2001

Does anyone have any suggestions on how to do this? Each record in the database has a submitted date field.

Cheers,

Tom

 

[savok]

In the selection formula put something like


{table.date} in {?Date_Start} to {?Date_End}

 

[kenhamady]

That is correct, assuming that you have created two parameter fields called start date and end date. Or you could just put in the literal values:

{table.date} in Date(2001,1,20) to Date(2001,2,19)


The syntax for literals is:
Date( YYYY,MM,DD ) Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal