Crystal Reports date range Friday noon to Sunday noon

Message

   Hi All -  I am trying to create a date range from every Friday noon to Sunday noon that checks vehicle mileage for that period.   The report would be run on Sunday afternoon.  I can't seem to get this to work.  

For the Friday start date :

if {CALENDAR_DAYS.CAL_DOW_NUM} = 6   then
DateAdd("H", 12, {CALENDAR_DAYS.CAL_DATE})

and for the Sunday date:

if {CALENDAR_DAYS.CAL_DOW_NUM} = 1 then
DateAdd("h", 12, {CALENDAR_DAYS.CAL_DATE})

I then set the record selection to:

{METER_JNL.METER_DATE} in DateTime (CDate({@startdate})) to DateTime (CDate({@Sunday}))

Any suggestions would be greatly appreciated.  Thanks. 

Edited by jimbo33 - 13 Dec 2011 at 3:10am