[AccessD] weekdays and numbers

Doris Manning mikedorism at verizon.net
Fri Aug 15 04:18:42 CDT 2008


Month(YourDateField)

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Friday, August 15, 2008 7:11 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list