Exclude records from a report that are not created between Mon - Fri 1

[nathanharcup]

Hi All,

I'm running Crystal 11r2 and was wondering if anyone has a selection criteria formula example of how I can exclude records that were not created between Monday - Friday 9am to 5pm?

Thanks

 

[lbass]

dayofweek({table.datetime}) in 2 to 6 and
time({table.datetime}) in time(9,0,0) to time(17,0,0)

If you don't want to include 5:00, you would use: time(16,59,59).

If it is a factor, this would be more efficient if you created SQL expressions to replace the day of week and time conversions.

-LB