Just need data from Monday - Friday 1

[porps]

Hola,

I'm new to CR (using CR10). I'm pulling data from an Oracle db. I want to pull the "tickets" from this database for 2 months, but I just want the tickets that were assigned from Monday-Friday. I don't care about the data from the weekends? What is the easiest way to do that?

Thanks for the help!

 

[IanWaterman]

function dayofweek(datefield) returns number 1-7, where monday is 2 and friday 6.

Filter your data
dayofweek(datefield) in [2 to 6]

Ian