Query by day of the week

[Vandelay]

How do I do a query that would return every 'Tuesday' or every Nth day of the week?

 

[nexcar]

There is a function that you can use to enter a date and it will return the day of the week example:

Dim MyDate, MyWeekDay
MyDate = #February 12, 1969# ' Assign a date.
MyWeekDay = Weekday(MyDate) ' MyWeekDay contains 4 because
' MyDate represents a Wednesday.

Here is the syntax:
WEEKDAY(serial_number,return_type)

Serial_number is a number that represents a date or text in date format, such as "4-1-1999" or "31-Oct-2000".

Return_type is a number: for Sunday = 1 through Saturday = 7, use 1; for Monday = 1 through Sunday = 7, use 2; for Monday = 0 through Sunday = 1, use 3.


Just key your IF statement using this function.


RUN FunnySignatureMessage

 

[Vandelay]

Where do I do this at? In the query window?

 

[nexcar]

You can. Here is a SQL code example:


SELECT *
FROM [yourTable]
WHERE weekday([dateField] = 3



RUN FunnySignatureMessage