[AccessD] weekdays and numbers

Hello Gustav,

i used Weekday in the expression (before i asked at accessd), without the ", 2" after my fielddate, but became no result. With the ", 2" i worked fine. Why?

Can i also get the month in an extra field with one expression?
The result then must be:

Date               Month
04-05-2008         05
04-05-2008         05
11-07-2008         07


Thanks

Pedro






Hi Pedro

You could filter on: 

  Where Weekday([YourDateField], 2) In (1, 5)

and count records.

If you only wish to count distinct dates, you can create a Select Distinct query first and feed that to the query where you count.

/gustav



>>> pedro at plex.nl 14-08-2008 13:09 >>>
Hello Group,

i have a list of dates and i need to now how many dates are on friday or monday.
The dates kan be present more then ones (notation is: dd-mm-yyyy).

How can i calculate this?

Thanks

Pedro Janssen