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:
Any suggestions would be greatly appreciated. Thanks.
Edited by jimbo33 - 13 Dec 2011 at 3:10am