Date\Time Formula Question 1

[Jonchill]

I'm trying to restrict a Date\Time to Monday - Friday 08:00 - 18:00 but cannot work out how to do it. My current formula is {InterfaceTraffic.DateTime} in DateTime (2007, 04, 01, 00, 00, 00) to DateTime (2007, 04, 22, 00, 00, 00).

Could someone help me put a filter in to the results only show Monday - Friday 08:00 - 18:00.

Thanks

Jon

 

[dgillz]

So are you getting an error message? If so please post the message

Or are you just getting undesireable results? If so please post current results and desired results.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Jonchill]

The output I'm getting is every day of the week and every time through out the day (256 pages worth) and what I want is to have the report only show Monday - Friday 08:00 - 18:00.

I can send the output and report through e-mail if required.

Thanks

Jon

 

[lbass]

Try:

date({InterfaceTraffic.DateTime}) in Date (2007, 04, 01) to Date (2007, 04, 22) and
dayofweek({InterfaceTraffic.DateTime}) in 2 to 6 and
time({InterfaceTraffic.DateTime}) in time(8,0,0) to time(18,0,0)

-LB

 

[Jonchill]

LB

Your Formula worked a treat thanks.

Jon