如何用asp函数取出一周以内的时间呢,

   
 我用
  playtime我自己建的日期型字段数值
    sql="select * from article_film where datediff("ww",playtime,now())=0"

也用过
    newdate=dateadd("d",6,date())
    sql="select * from article_from where playtime between #"&date()&"# and #"&newdate&"# "
可都不行,希望哪位高手帮帮解答一下,小弟万分感激