weekday trends query

J

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?
 
C

chris

To pick only tuedays from your list of dates use

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

note 1 = sunday
2 = monday etc
 
Top