weekday trends query

  • Thread starter Thread starter jamesd
  • Start date Start date
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?
 
To pick only tuedays from your list of dates use

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

note 1 = sunday
2 = monday etc
 
Back
Top