CR 8.5 Select Expert Question

[tmozer]

When you choose "is between" from the Select Expert drop down, does Crystal Report select include the limits in the selection?

For example, if I am using two date parameters such as 10/1/2004 and 10/27/2004, will all the records including 10/1 and 10/27 be included?? Or will I get only 10/2 through 10/26???

 

[teknogeek9]

Yes, the 10/1 and 10/27 records will be included. If you want to confirm this, view the SQL statement.

 

[kskid]

You can verify by looking in Show SQL Query, which will create the following

table.date >= {ts '2004-10-01 00:00:00.00'} and
table.date < {ts '2004-10-28 00:00:00.00'}

If you want to exclude the ending date in your select expert record selection, use to_ instead of to

{table.date} in date(2004,10,1) to_ currentdate

will produce

table.date >= {ts '2004-10-01 00:00:00.00'} and
table.date < {ts '2004-10-28 00:00:00.00'}

whereas

{table.date} in date(2004,10,1) to currentdate

will produce

table.date >= {ts '2004-10-01 00:00:00.00'} and
table.date < {ts '2004-10-29 00:00:00.00'}

Cheers,

-larry