Displaying dates for a certain day

[mans]

Hello,

I have a simple table (Access2000), one column with the date (table1.date) and another with a name (table1.name). Can some one please post the SQL statement required to display all of the dates and names that fall on a Thursday.

Thank You

 

[THWatson]

mans
To get all dates that fall on a Thursday, put the following criteria in your date column...
Weekday([YourDateField])=4

By the way, it is better not to use Date and Name as the names for field in a table. They are reserved words in Access. Rename your Date field in table1 to something such as MyDate or whatever you like.

For example, Date() is used to derive the current date. So if your field is named Date this just runs into all kinds of trouble.

Tom

 

[TheAceMan1]

How are ya mans . . . . .

[blue]SELECT Table1.Date, Table1.Name
FROM Table1
WHERE ((Weekday([Date])=5));[/blue]

Also, in table design view, add the following in the [blue]Format Property[/blue] for Date:

[blue]ddd mmm d\,yyyy[/blue]

The date will display as Tue Jan 4,2004 . . . . .

See Ya! . . . . . .

 

[THWatson]

mans
The AceMan1 is absolutely correct in using
Weekday([DateField])=5 to return Thursday.

I surely didn't intend to mislead. Somehow I was looking at the wrong dates and just went by them.

Thanks, AceMan1, for the correction!

Tom

 

[mans]

Thank you very much Tom and AceMan1.