All,
I am trying to create a query that returns a results set of weekday transactions only. I am unsuccessfully using the DayofWeek function as follows:
//If {Trips.Trip Date} >= Date (2011,07,01) and {Trips.Trip Date} <= Date (2012,06,30)
//and (DayofWeek({Trips.Trip Date},1) = 2
//or DayofWeek({Trips.Trip Date},1) = 3
//or DayofWeek({Trips.Trip Date},1) = 4
//or DayofWeek({Trips.Trip Date},1) = 5
//or DayofWeek({Trips.Trip Date},1) = 6)
// then
// average {Trips.Passengers})
// else
However, I believe, only the number of weekdays since July 1, 2011 is returned. My hope is to get the correct syntax to bring back only weekdays of passengers. Can some one please help?