RE: [sqr-users] Weekdays

["Patel, Samir" <SPatel@FDIC.gov>]

You can try something like this:

 

let #days_diff = datediff($date_end,$date_beg,'DAY')

 

!Convert from native format to YYYY-MM-DD

do Convert-To-DTU-Date($date_end,$date_end_tmp1)

 

While #days_diff >= 0

    

    !Determine the day of week 

    do dtu-dayofweek($date_end_tmp1,$dayofweek)   !datemath.sqc 

    let $dayofweek = UPPER($dayofweek) 

 

    !If weekday, add 1. 

    If ($dayofweek <> 'SUNDAY') AND ($dayofweek <> 'SATURDAY') 

        add 1 to #nbr_weekdays 

    End-If 

 

    do Convert-From-DTU-Date(,$date_end_tmp1,,$date_end_tmp2) !datemath.sqc 

 

    let $date_end_tmp1 = dateadd($date_end_tmp2,'DAY',-1) 

 

    do Convert-To-DTU-Date($date_end_tmp1,$date_end_tmp1)   !datemath.sqc

 

    let #days_diff = #days_diff - 1

 

End-While

 

Also, don't forget to declare your date variables in the begin-setup
section.

 

Hope that helps.

 

Samir

 

 

-----Original Message-----
From: Peter Clark [mailto:PGCLARK@vac-acc.gc.ca] 
Sent: Monday, September 08, 2003 12:00 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Weekdays

 

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

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