Time Intervals in crystal 1

[Tubby6]

How do i create a time interval in crystal v10.
I have the following

{HPD_HelpDesk.Create Time} >= DateTime (CurrentDate-7, Time(16, 00, 00 ) )

This results in all the data seven days before today's date AFTER or equal to 4.
BUT
I WANT data from seven days ago from 4 to 12..
every day..
for example, Monday -- data between 4 to 12
tuesday -- data between 4 to 12

etc. until today's date..

can anyone please help..
My field requires there to be a data as shown above...
and if i put


{HPD_HelpDesk.Create Time} >= DateTime (CurrentDate-7, Time(16, 00, 00 ) ) to DateTime (CurrentDate-7, Time(00, 00, 00 )

it ignores the end of the statement and gives me all the data after 4 from seven days ago until today

again im looking to obtain data from a time interval 4-12 each day starting from seven days ago.

i cannot do prompts. it has to be dynamic.

-tubby

 

[lbass]

{HPD_HelpDesk.Create Time} >= CurrentDate-7 and
time({HPD_HelpDesk.Create Time}) in time(16,0,0) to time(23,59,59)

I think 12 midnight belongs to the next date.

-LB

 

[Tubby6]

OMG I THINK THAT WAS THE PROBLEM... OMG!!! THANK U SO MUCHHH IN WORKED... U ARE THE BEST.
YOUR HELP IS MUCH APPRECIATED!!!

I HAD A PREVIOUS THREAD BUT IT WASN'T ANSWERED PROPERLY
!!
THANKS SO MUCH
-TUBBY