Range date selection with 2 params... not like SQL between ?!?

[FredGexel]

Hello C.R. users,

I was wondering if anyone knew how come the IN TO Crystal Reports statement wont do like the Between SQL statement.


here's my selection:
====================
if IsDate(CStr({?date_from})) = True and IsDate(CStr({?date_to})) = True then
{temps.temps_date} in {?date_fromk} to {?date_to}


here's the format of my data:
=============================
the temps_date field contains the date of the Sunday of the week. (2001/07/01, 2001/07/08, ...)


here's my parameters value (YYYY/MM/DD):
========================================
I enter 2001/07/01 as date_from and 2001/07/08 as date_to


here's the wanted result:
=========================
only the records where the temps_date is 2001/07/01


here's the given result:
========================
the records between 2001/06/17 to 2001/07/08 (how come ?!?)


It would be so great if you guys know how come
(My boss want that report to be exact badly !!!)

 

[FredGexel]

OHHHHHH.... No prob, i got it Was a stupid mistake ...