DatePart to find single days / AM / PM

  • Thread starter Thread starter Cory
  • Start date Start date
C

Cory

I have a list of dates that I would like to be able to
filter <> Saturday. Would DatePart work, and what syntax
would I use... "w"<>7?

Thanks!
 
Cory said:
I have a list of dates that I would like to be able to
filter <> Saturday. Would DatePart work, and what syntax
would I use... "w"<>7?

WHERE WeekDay([YourDateField]) <> 7
 
Back
Top