Using DateDiff to Get Number of Mondays, Tuesday, etc.

[CT Witter]

I would like to determine the number of Mondays, Tuesdays, etc. for a set time period. For example, 1/1/2004 - 7/31/2004, how many of each day of the week were there?

Any suggestions.

CT

 

[Norie]

Why not use the Weekday function on the date field concerned?

 

[CT Witter]

I don't follow, weekday only takes a single date argument. Can you please clarify?

 

[Norie]

Use it as an expression in a query.

eg.

SELECT Weekday([TransDate]) AS [Day of Week], Count(Transactions.TransDate) AS CountOfTransDate
FROM Transactions
GROUP BY Weekday([TransDate]);

 

[CT Witter]

Thanks, that helped a lot!