[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Weekdays

Subject: [sqr-users] Weekdays
From: "Peter Clark" <PGCLARK@vac-acc.gc.ca>
Date: Mon, 08 Sep 2003 13:00:13 -0300
List-help: <mailto:sqr-users-request@sqrug.org?subject=help>
List-id: This list is for discussion about the SQR database reporting language from Brio Software. <sqr-users.sqrug.org>
List-post: <mailto:sqr-users@sqrug.org>
List-subscribe: <http://www.sqrug.org/mailman/listinfo/sqr-users>,<mailto:sqr-users-request@sqrug.org?subject=subscribe>
List-unsubscribe: <http://www.sqrug.org/mailman/listinfo/sqr-users>,<mailto:sqr-users-request@sqrug.org?subject=unsubscribe>

I have a requirement to determine the number of weekdays (Monday through 
Friday) in a range between two specified dates of any year. (e.g. date1 = 
2003-09-01 date2 = 2003-09-24, number of weekdays = 18)

Before I set about inventing this wheel, I thought I'd first check to see if 
anyone else has developed such a procedure.

Thanks in advance.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

Prev by Date: [sqr-users] DATEADD function
Next by Date: RE: [sqr-users] DATEADD function
Previous by thread: RE: [sqr-users] DATEADD function
Next by thread: RE: [sqr-users] Weekdays
Indexes: [ Thread] [ Author] [ Date]
SQR-USERS List and Archive Info
SQRUG Home Page