weekday trends query

[jamesd]

I have my date field set as long date format (dddd mm dd
yy) and need to do trends according to weekdays. Is this
possible? For instance when I try to pull up all activity
on Thursdays, it comes up with nothing. How would I go
about separating the weekday?

 

[chris]

To pick only tuedays from your list of dates use

DatePart("w",[datefield],1) = 3

note 1 = sunday
2 = monday etc