Date Range Question

[wsproperties]

What is the best way to display a date range when you know which date range you want and then do a booleon based on that range. Here is my example.
I have a field called gifteffectiveDate. For each transaction if the gifteffective date occured between 07/01/2007 and 06/30/2008 I want to display that range. I also want to do a booleon of true or false. In the database, the date is reflected as a date/time display such as 7/1/2007 12:00:00AM

 

[kskid]

What do you mean by displaying the date range? isn't 7/1/2007 to 6/20/2008 the range? If that was in your record selection, then all you would get would be

{table.gifteffectivedate} in [date(2007,7,1) to date(2008,6,30)]

making all of them TRUE.

What are you trying to accomplish?

It would also help if you gave the Crystal version and database you are using so we can tailor the solution to your Crystal version and database.