Thread: weekdayName function

Hi,

I have a column field DateTime in (dd/mm/yy hh:mm) format

I trying to figure out how to extract out the rows based on current week.

Now()
WeekdayName()
.... ?

How to link them together to get you current week ?!?!?


Thanks

SELECT Table1.DateTime, Weekday([DateTime])=Weekday(Now()) AS Expr1
FROM Table1;

Result:
DateTime Expr1
18/1/2011 0
19/1/2011 0
18/2/2011 -1
19/2/2011 0
20/2/2011 0
21/2/2011 0


current week is 8 = 13/02/2011 to 19/02/2011

but 19/02/2011 i got 0 ?

Try this

SELECT datetime.Date, Weekday([date]) AS Expr1
FROM [datetime]
WHERE (((Weekday([date]))=Weekday(Now())));